PHWinfo - Afficher un message - Getting record position in sql server 2000

26/03/2008, 00h47

Tom van Stiphout (no.spam.tom7744@cox.net) writes:
> There rarely is a good reason for needing a row number. What is yours?

The row_number() function is one of the absolutely most useful additions
to SQL 2005. The only thing that can compete is the new error handling.
There are so many problems which are solved easily and efficiently with
the row_number function.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

26/03/2008, 00h47	#5
Erland Sommarskog Messages: n/a Hébergeur:	Re: Getting record position in sql server 2000 Tom van Stiphout (no.spam.tom7744@cox.net) writes: > There rarely is a good reason for needing a row number. What is yours? The row_number() function is one of the absolutely most useful additions to SQL 2005. The only thing that can compete is the new error handling. There are so many problems which are solved easily and efficiently with the row_number function. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx