SQL2005加入了ROW_NUMBER() 函数,用法如下:
select ROW_NUMBER() OVER (ORDER BY name) AS RowNumber,* from sysobjects
其中:ORDER BY子句不能为空。
分页语句如下:
WITH T AS (SELECT ROW_NUMBER() OVER (ORDER BY name) AS RowNumber,* FROM SYSOBJECTS) SELECT * FROM T WHERE RowNumber BETWEEN 1 AND 10