DECLARE @PAGEINDEX INT
DECLARE @PAGESIZE INT
SET @PAGEINDEX=1
SET @PAGESIZE=50
SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY CNO_CODE) AS ROWNUM,
CNO_CODE
FROM ODMDOC ) AS D
WHERE ROWNUM BETWEEN (@PAGEINDEX-1)*@PAGESIZE+1 AND @PAGEINDEX*@PAGESIZE
ORDER BY CNO_CODE
扫一扫
08-28
494
494
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
