大数据量SqlServer效率分页

发布时间：2020-12-12 15:02:08 所属栏目：MsSql教程来源：网络整理

导读：转载请注明出处http://blog.csdn.net/xugangjava SET @rowsPerPage = 10? ??? SET @pageNum = 3? ????? ??? With SQLPaging? ??? As? ??? (? ??? Select Top(@rowsPerPage * @pageNum) ROW_NUMBER() OVER (ORDER BY id) as resultNum,id? ??? FROM myTable?

转载请注明出处http://blog.csdn.net/xugangjava

SET @rowsPerPage = 10?
???

SET @pageNum = 3?
?????
??? With SQLPaging?
??? As?
??? (?
??? Select Top(@rowsPerPage * @pageNum) ROW_NUMBER() OVER (ORDER BY id) as resultNum,id?
??? FROM myTable?
??? )?
??? select * from SQLPaging where resultNum > ((@pageNum - 1) * @rowsPerPage)??

分页不要用where not in 有些情况下效率低下

转成通用的分页存储过程

http://www.voidcn.com/article/p-xvajnsic-ts.html

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!