SQLServer 2008（1）—— SQLServer 2008语法大全

--生成行号，其中 order by 必须存在
select rownum = row_number() over(order by id) from userinfo

-- sqlserver2008 分页查询
select aSysTable.*, rownum = row_number() over(order by id) from ( select top 10 id,userCode,userName,bankCode,bankInfo,comCode,deptCode,email,idCardNo,phone from userinfo) as aSysTable