分页的例子
DECLARE @pagesize AS INT,
@pagenumber AS INT;
SET @pagesize=2
set @pagenumber=1
;WITH PAGE AS (
SELECT ROW_NUMBER()OVER(ORDER BY ID,content)AS rownum,
ID,CONTENT FROM #T4
)
SELECT rownum,ID,CONTENT FROM PAGE
WHERE rownum>@pagesize*(@pagenumber-1)
AND rownum<=@pagesize*@pagenumber