Posted by Erland Sommarskog on 09/20/05 00:46

helmut woess (hw@iis.at) writes:
> Am Sun, 18 Sep 2005 17:58:46 GMT schrieb Dan Guzman:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;835188
>
> Hmmm, i am not sure what to do with this information. If it is a bug why
> was it not fixed in one of the next service packs?
> And there is no definition what the result will be after fixing the bug.
> And i did not find any information if this bug is fixed in SQL2005.

The behaviour is the same in SQL 2005.

But the funny thing is that Books Online for SQL 2005 explicitly says that
you should get NULL back in this case...
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: IDENT_CURRENT and empty table
• Prev in forum: Re: IDENT_CURRENT and empty table
• Thread view: Re: IDENT_CURRENT and empty table

[Reply to this message]