常用SQL语句

最近需要对一个数据库进行重构,涉及很多对SQL的操作,在这里记录一下常用到的SQL语句.以备使用.

1.删除重复记录

select distinct * into #Tmp from tbl_map_team
drop table tbl_map_team

select * into tbl_map_team from #Tmp

drop table #Tmp