sql sever去掉数据库重复数据

------------------------------------去掉数据库重复数据-------------------------------------
SELECT   distinct   *   into   #temp   from   tablename       
DELETE   tablename       
go     
INSERT  tablename   select   *   from   #temp     
go     
DROP   table   #temp  
------------------------------------------------------------------------------------------