SQL2012的新分页方法

[goohugo]

DECLARE @PageNumber INT = 6
DECLARE @RowsCountPerPage INT = 10

SELECT  BusinessEntityID ,
        FirstName ,
        LastName
FROM    Person.Person
ORDER BY BusinessEntityID
        OFFSET ( @PageNumber - 1 ) * @RowsCountPerPage ROWS
 FETCH NEXT @RowsCountPerPage ROWS ONLY