Microsoft KB Archive/163447

{|
 * width="100%"|

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

 * }

Q163447

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

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

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600