【清清月兒】用SQL 2005的ROW_NUMBER() 實現分頁功能

DECLARE @pagenum AS INT, @pagesize AS INT
SET @pagenum = 2
SET @pagesize = 3
SELECT *
FROM (SELECT ROW_NUMBER() OVER(ORDER BY newsid DESC) AS rownum,
        newsid, topic, ntime, hits
      FROM news) AS D
WHERE rownum BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesize
ORDER BY newsid DESC

aspx裡面只需給SQL傳入pageid和條數即可。

CSDN上還有個儲存過程實現分頁的程式碼：

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12639172/viewspace-329649/，如需轉載，請註明出處，否則將追究法律責任。