1:随机取出数据表中数据

select top n * from table order by newid()

2:取出插入表中的最新ID

insert into table vlues() select @@identity

3:取出表中10-20的数据

select top 10 * from table where id not in(select top 20 id from table)

4:判断字段并赋于不同值

select columnName1=

case columnName1

when 1 then 'value'

end

from table

5:获取最后更新时间的所有列

select  max(addDate) ,userName from table group by userName order by addDate desc

6:删除表中所有重复记录

delete from table where columnName =(select columnName from table group by columnName

having count(*)>1)

7:获取日期和时间

select  convert(char(20),getDate(),20) value from table
select  convert(char(8),getDate(),108) value from table