SQL Server 2000 删除完全重複的多餘記錄

SQL Server 2000 删除完全重複的多餘記錄

select distinct * into #Tmp from tableName

drop table tableName

select * into tableName from #Tmp

drop table #Tmp