专注于互联网--专注于架构

sqlrownumber:用SQL 2005的ROW_NUMBER() 实现分页功能

DECLARE @pagenum AS INT, @pagesize AS INTSET @pagenum = 2SET @pagesize = 3SELECT *FROM (SELECT ROW_NUMBER OVER(ORDER BY sid DESC) AS rownum, sid, topic, ntime, hits FROM s) AS DWHERE rownum BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesizeORDER BY sid DESC aspx里面只需给SQL传入pageid和条数即可 CSDN上还有个 [阅读全文] [PDF]