sqlserver2005使用row_number() over分页的实现方法，需要的朋友可以参考下。

语法：ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN) 例子: 代码如下: select * from ( 　　　　select *, ROW_NUMBER() OVER(Order by a.CreateTime DESC ) AS RowNumber from table_name as a 　　) as b 　　where RowNumber BETWEEN 1 and 5 将会返回table表 其中有一列名字为 RowNu