1.坑
用惯了mysql,查询时就习惯select * from xx where xx=null或者xx=’’
到了SqlServer不管用。。。
2.记录
查询第10条数据:
SELECT * FROM
(
SELECT ROW_NUMBER() OVER (ORDER BY id ASC) AS RowNumber, *
FROM 表名
) A
WHERE A.RowNumber = 10
查询xx字段为null的数据
select * from 表名 where xx is null or xx2 is null or xx3 is null