分页查询sqlserver2005数据

  SELECT TOP 500 *
FROM
        (
        SELECT ROW_NUMBER() OVER (ORDER BY bianhao) AS RowNumber,* FROM tguanliyuan
        ) A
WHERE RowNumber > 500*(1-1)