sql 2005 引入新方法
SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY KEYFIELD DESC) AS ROWNUM,* FROM TBLNAME) AS T WHERE ROWNUM> START AND ROWNUM <= END
其中
keyfield为 tableName的一个字段(最好是主键)
tableName为查询的表名
desc 可以换为 asc
start 为开始要取的记录
end要取的结尾记录start+pagesize