温暖大侠

摘要： 1.所有字段均重复的记录（重复记录保留一条）Select distinct * into #Tmp from tblNameDrop table tblNameSelect * into tblName from #TmpDrop table #Tmp设计不周产生的，增加唯一索引可解决2.所有字段均重复的记录（重复记录保留一条）Select distinct * into #Tmp from tblNameDrop table tblNameSelect * into tblName from #TmpDrop table #Tmp设计不周产生的，增加唯一索引可解决3.保留ID最小的记录,删除 阅读全文