Custom Paging in 2.0

Check out Scott Mitchell’s treatment of the subject on the 4Guys website:

As someone who has had to create a long stored procedure to handle custom paging in 1.1 (create temporary table, generate query to load IDs into the table, query the temp table with some variables to pull out the records that you want), I am especially excited about the Row_Number() keyword in SQL Server 2005, and the savings in development time (debugging & headaches) that will come along with its proper use.

Tagged , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *