曾经用过的Sql Server分页方法小结
摘要：工作这些年, 数据库分页也用过几种方案, 总结如下: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
阅读全文
posted @
2012-02-14 22:13
BobLiu
阅读(634)
推荐(0) 编辑
