Fast Web paging in SQL Server 2005

Friday Dec 15th 2006 by Staff

Learn how to design a stored procedure to page data automatically using the new ROW_NUMBER ranking function in SQL Server 2005.


Paging, the grouping together of records usually for display purposes, has never been easy to accomplish or very efficient in SQL Server. In the past, developers would have to design their stored procedures to accommodate paging using temp tables, or would have to return the entire result set back to the client and page the data set in that fashion. Neither method was very desirable from the point of view of the developer or the DBA.

The article continues at

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved