SQL Server 2005 Paging Results
With SQL Server 2005 it is now a lot easier to use paged
queries than in previous versions. I will be using NorthWind
db (mostly) so you can also use the examples I have
provided. I will keep the examples simple; anything complex
will only cause confusion. I will start with "traditional"
methods such as SELECT, TOP, and
then move onto the specific SQL Server 2005 paging examples.