SQL SERVER2005的row_number()实现分页

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY [id] ASC) AS RowNum, * FROM table) AS T WHERE RowNum BETWEEN X AND Y