SQL Server分页SQL

sql server 2005

WITH OrderedOrders AS
(SELECT *,
ROW_NUMBER() OVER (order by [id])as RowNumber　　--id是用来排序的列
FROM table_info ) --table_info是表名
SELECT *
FROM OrderedOrders
WHERE RowNumber between 50 and 60;

http://www.ljnid.cn/?id=145

SELECT TOP 页大小 *
FROM
Users
WHERE
(ID NOT IN (SELECT TOP (页大小*(页数-1)) ID FROM Users ORDER BY ID DESC))
ORDER BY
ID DESC

http://blog.csdn.net/leizhipan/archive/2006/10/01/1313508.aspx
重要参考页：
http://icansoft.blog.51cto.com/268543/54310