SQL Server 数据库分页

1。SQL Server 2005分页支持

SELECT *
FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, *
from Sales.CreditCard) as table
where rowNum> 0 and rowNum

2。创建临时表，临时表中包含自动生成的序号和记录的唯一ID，用序号进行分页

3。使用双TOP语句