分页的例子 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
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