Home Forums Article Discussions Article Discussions by Author Discuss content posted by sdorris-1150234 What is the value of SCOPE_IDENTITY() RE: What is the value of SCOPE_IDENTITY()
Paul White
SSC Guru
Points: 150467
More actions
April 19, 2010 at 10:20 pm
#1154275
Given the number of inconsistencies and bugs, I'd be quite happy to see @@IDENTITY and SCOPE_IDENTITY removed from the product. I very much prefer the OUTPUT clause for this purpose.
http://connect.microsoft.com/SQLServer/feedback/details/328811/scope-identity-sometimes-returns-incorrect-value
Paul WhiteSQLPerformance.comSQLkiwi blog@SQL_Kiwi