sqlserver分页查询
摘要：
SQL Server 2005引入的新方法。SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY keyField DESC) AS rowNum, * FROM tableName) AS t WHERE rowNum > start AND rowNu... 阅读全文
posted @ 2014-05-22 02:55 王者風雲 阅读(186) 评论(0) 推荐(0)
浙公网安备 33010602011771号