从sql server2005起，已经支持ROW_NUMBER() 函数了，例如：
SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY EmployeeName) AS Row, EmployeeId, EmployeeName, Salary FROM Employees) AS EMP WHERE Row BETWEEN 2 AND 4
但sql server2005以前版本不支持，可使用identity(int,1,1)这种方式获取。