An alternative way to page results using OFFSET AND FETCH.

Database used in this example is Adventure Works for SQL Server 2014. You can download the database here.

This stored procedure will return paged results from the HumanResources.Employee table.

Execution results:

SQLPage1

 

Like this post? Share it!
Free WordPress Themes, Free Android Games