对于大量数据的分页工作感觉还是利用存储过程或在执行查询语句的时候就直接分页,将全部数据查询出来再到页面上分页显然不够科学.下面为用一条sql语句完成分页的语法:
SELECT TOP 每页记录数 *
FROM TestTable
WHERE (ID >=
(SELECT MAX(id)
FROM (SELECT TOP (每页记录数*当前页数)+1 id //当前页数从0编号
FROM TestTable
ORDER BY id) AS T))
ORDER BY ID
用DESC排序时,需要改成:
SELECT TOP 每页记录数 *
FROM TestTable
WHERE (ID <=
(SELECT MIN(id)
FROM (SELECT TOP (每页记录数*当前页数)+1 id //当前页数从0编号
FROM TestTable
ORDER BY id DESC) AS T))
ORDER BY ID DESC