22,207
社区成员
发帖
与我相关
我的任务
分享
DECLARE @pageIndex INT,@pageSize INT
SET @pageIndex=6
SET @pageSize=5
SELECT rid,number,TYPE,t.[status] FROM (
SELECT ROW_NUMBER() OVER (ORDER BY number) AS rid ,*
FROM [master].dbo.spt_values AS sv
WHERE sv.[type]='P' AND sv.number>0
) AS t
WHERE t.rid>@pageIndex*@pageSize AND t.rid<=(@pageIndex+1)*@pageSize
/*
rid number TYPE status
-------------------- ----------- ---- -----------
31 31 P 0
32 32 P 0
33 33 P 0
34 34 P 0
35 35 P 0
*/
你参照这个来做你的分页吧