Fast Web paging in SQL Server 2005

Friday Dec 15th 2006 by DatabaseJournal.com Staff
Share:

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

[From Builder.com]

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 http://builder.com.com/5100-6388_14-6141785.html?tag=sc

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