还是先上代码吧 ，可以先看 SQL语句去掉重复记录，获取重复记录 代码如下: ALTER procedure [dbo].[PROC_ITEMMASTER_GETUNIQUE] PAGEINDEX INT,uid int,itemnumber varchar(50) AS begin tran –开始事务 drop table [ItemMaster].[dbo].[testim] –删除表 –把不重复记录转存到testim中 select * into [ItemMaster].[dbo].[
old = File.open(ARGV[0]).collect new = File.open(ARGV[1],”a+”) for i in 0..old.length-1 new.write(old.uniq[i]) end ##或简单两行也可以如qc.rb old = File.open(ARGV[0]).collect puts old.uniq 然后qc.rb dic.dic >new.dic
