MS-SQL删除重复数据的SQL语句

select distinct * into #Tmp from TableName
drop table TableName
select * into TableNamefrom #Tmp
drop table #Tmp