摘要： 工作这些年, 数据库分页也用过几种方案, 总结如下:1.用row_number函数及临时表分页, 适用sql 2005/2008. 大致思路如下:SELECT *, ROW_NUMBER() OVER (ORDER BY OrderID DESC ) AS rownumber into #SOFROM tbl_SalesOrderWhere condition...SELECT *FROM #SO Where (#SO.rownumber between 1 AND 15order by #SO.RowNumber 2.用row_number函数及表表达式分页, 适用sql 2005/2008 阅读全文