首页 >后端开发 >php教程 >SQL Server 2005 提供的分页查询支持_PHP教程

SQL Server 2005 提供的分页查询支持_PHP教程

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB原创
2016-07-13 17:02:57794浏览

今天刚刚看到,没有测试性能。
SELECT *
FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, *
from Sales.CreditCard) as table
where rowNum> 0 and rowNum

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/630990.htmlTechArticle今天刚刚看到,没有测试性能。 SELECT * FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, * from Sales.CreditCard) as table where rowNum 0 and rowNum50...
声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn