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.