分页存储过程

---------------------- 方法1-------------------
利用Not In和SELECT TOP分页)
SELECT TOP 10 *
FROM users
WHERE (indexId NOT IN
(SELECT TOP 30 indexId
FROM users
ORDER BY indexId))
ORDER BY indexId

SELECT TOP 页大小 *
FROM TestTable
WHERE (ID NOT IN
(SELECT TOP 页大小*页数 id
FROM 表
ORDER BY id))
ORDER BY ID
---------------------- 方法2------------------
二：(利用ID大于多少和SELECT TOP分页
SELECT TOP 10 *
FROM users
WHERE (indexID >
(SELECT MAX(indexID)
FROM (SELECT TOP 20 indexID
FROM users
ORDER BY indexID) AS T))
ORDER BY indexID


SELECT TOP 页大小 *
FROM TestTable
WHERE (ID >
(SELECT MAX(id)
FROM (SELECT TOP 页大小*页数 id
FROM 表
ORDER BY id) AS T))
ORDER BY ID