Paging with SQL Server has always been a pain. Although SQL Server 2005 introduced some features that made it possible to page results efficiently more easily than ever before.
Paging in SQL Server 2005 at 15 Seconds shows you how to do it with the new ROW_NUMBER() function.
Add your comment below, or trackback from your own site.
Subscribe to these comments.
Be nice. Keep it clean. Stay on topic. No spam.
You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>