如何删除表中的重复记录?
---------------------------------------------------------------
select distinct * into #temp from tab
delete tab
insert tab select * from #temp
drop table #temp
如何删除表中的重复记录?
---------------------------------------------------------------
select distinct * into #temp from tab
delete tab
insert tab select * from #temp
drop table #temp