Posted by Erland Sommarskog on 10/02/55 11:56

Hugo Kornelis (hugo@perFact.REMOVETHIS.info.INVALID) writes:
> Assuming that the IDENTITY function works as advertised, you'll never be
> able to get a situation with MIN(id) other than 1 and MAX(id) other than
> 1000 (assuming the COUNT(*) check is passed).

It's difficult to say what is advertised. We know that you should not
reply on ORDER BY. Here is a TOP, that I don't really whether I can trust.

The paranoid check is cheap. The cost for an unexpected result is expensive.


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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: User authentication
• Prev in forum: Re: Normalizing a Crosstab
• Thread view: Re: Case help and Identity help

[Reply to this message]