Rants and Raves

Thanks for visiting my blog!

SQL Server 2005 Paging Demo
SQL Server 2005 Paging Demo
Shawn Wildermuth
November 4, 2006
Databases SQL Server

Url: http://wilderminds.blob.core.windows.net/downloads/pagingdemo.zip

I got thinking about writing custom paging code with the new SQL Server 2005 ROW_NUMBER, RANK, and DENSE_RANK functions.  I started playing around with code and ended up with this simple ASP.NET 2.0 example. It works with SQL Server 2005 and the Adventure Works sample database.  The example uses ad-hoc SQL so it would be easy to show how it works, but moving it into stored procs would be simple.

I’d love any feedback!

PagingDemo.zip

Creative Commons License
This work by Shawn Wildermuth is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License . Based on a work at wildermuth.com.