最近刚接触SQLSERVER,还不是太习惯,最近使用的两个小功能给大家看一下:
删除重复的数据:
select distinct * into #Tmp from tableNamedrop table tableNameselect * into tableName from #Tmpdrop table #Tmp
还有一个问题是好像SqlServer不能想oracle哪样,直接拿子查询当做表使用
只能
with tablename() as (select columnname from tablename1);或者select a.* from (select columnname from tablename) a