sql2005导入导出数据重复问题

一、利用临时表

       select distinct * into #test from casepicture

       select * from #test

       select * into casepicture from #test

 

二、利用分组

       SELECT caseid
       FROM cases
       GROUP BY caseid
       HAVING COUNT(caseid) > 1

       可以查看那些列重复了