用存储过程,定义一个游标一行行往后走,碰到相同的就删除declare @id int,@finger varchar(80),@width varchar(80),@hight int,@size varchar(10),@type varchar(80),@id2 int declare cursor delid for select id,finger,width,hight,size,type from table2open delidfetch next from delid into @id,@finger,@width,@hight,@size,@typewhile @@fetch=0begin if e...
|