先加入一个自增列,然后按自增列删除,然后删除自增列删除.
alter table [tblname]
add [colname] int IDENTITY(1,1) not null
select tempno ,flow_no from trade where [colname] = --重复的记录的tempno
delete from trade where tempno = --select出来的结果
drop column tempno
先加入一个自增列,然后按自增列删除,然后删除自增列删除.
alter table [tblname]
add [colname] int IDENTITY(1,1) not null
select tempno ,flow_no from trade where [colname] = --重复的记录的tempno
delete from trade where tempno = --select出来的结果