利用ROW_NUMBER()进行高效率的分页。

AD HOC PAGING： 就是指用页面的序号和页面的大小请求一个单独的页面。下面是例子。 DECLARE pagesize AS INT, pagenum AS INT; SET pagesize = 5; SET pagenum = 2; WITH SalesCTE AS ( SELECT ROW_NUMBER() OVER(ORDER BY qty, empid) AS rownum, empid, mgrid, qty FROM dbo.Sales ) SELECT rownu