BUG: @@IDENTITY Variable Not Handled Like a Global Variable |
Q163447
The @@IDENTITY value does NOT retain the last inserted value, as documented
in the SQL Server Books Online. It is treated more like a function
variable, which is inconsistent with the behavior of SQL Server global
variables and the online documentation.
To get the last identity value, use the @@IDENTITY global variable. This
variable is accurate after an insert into a table with an identity column.
However, this value is reset after an insert occurs into a table that does
not have an identity column.
Microsoft has confirmed this to be a problem in SQL Server version 6.0. This problem was corrected in SQL Server version 6.0 Service Pack 3 and later versions.
Additional query words: counter sequence random timestamp generating
Keywords : kbusage
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600
|
Last Reviewed: April 10, 1999 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |