select distinct * into #Tmp from fengongsi drop table fengongsi select * into fengongsi from #Tmp drop table #Tmp