BUG: @@IDENTITY Variable Not Handled Like a Global Variable

ID: Q163447

The information in this article applies to:
BUG #: 15675 (Windows: 6.0)

SYMPTOMS

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.


STATUS

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 SSrvGen kbbug6.00 kbfix6.00.sp3 
Version           : 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 8, 1999