SQL Server 2000 删除完全重复的多余记录 select distinct * into #Tmp from tableName drop table tableName select * into tableName from #Tmp drop table #Tmp