SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005 | Journey to SQL Authority with Pinal Dave

I was doing paging in SQL Server 2000 using Temp Table or Derived Tables. I decided to checkout new function ROW_NUMBER() in SQL Server 2005. ROW_NUMBER() returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. I have compared both the… Continue Reading...

Source: SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005 | Journey to SQL Authority with Pinal Dave