SQL SERVER 分页语句

SELECT ROW_NUMBER() OVER(ORDER BY ID ASC) AS rownum,* FROM TABLENAME；TABLENAME 为数据库表名，rownum为行号，ID为唯一标识符