- 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和条数即可。