SQL Server 2005 提供的分页查询支持
今天刚刚看到，没有测试性能。SELECT *
FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, *
from Sales.CreditCard) as table
where rowNum> 0 and rowNum<50
SQL Server 2005 提供的分页查询支持
热度1 评论 266
www.PHPzy.Com 网友分享于：
2018-10-02 12:10:32 浏览数44156次
SELECT *
FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, *
from Sales.CreditCard) as table
where rowNum> 0 and rowNum<50
PHP之友评论