摘要:最近需要对一个数据库进行重构,涉及很多对SQL的操作,在这里记录一下常用到的SQL语句.以备使用.1.删除重复记录select distinct * into #Tmp from tbl_map_teamdrop table tbl_map_teamselect * into tbl_map_team from #Tmpdrop table #Tmp
阅读全文
posted @ 2009-06-23 23:06
|
|||
06 2009 档案
摘要:最近需要对一个数据库进行重构,涉及很多对SQL的操作,在这里记录一下常用到的SQL语句.以备使用.1.删除重复记录select distinct * into #Tmp from tbl_map_teamdrop table tbl_map_teamselect * into tbl_map_team from #Tmpdrop table #Tmp
阅读全文
posted @ 2009-06-23 23:06
|
|||