binduram
Old Hand
Points: 306
More actions
May 20, 2002 at 3:27 pm
#78681
Can anyone explain the scope of SCOPE_IDENTITY() within a stored procedure...
What if two seperate calls are made to the same stored procedure at the same time. Could an incorrect value be returned.
Andy Warren
SSC Guru
Points: 119902
May 20, 2002 at 4:52 pm
#429495
No, it will always return the correct value. Compare this behavior to @@Identity which returns the last identity inserted for that user.
Andy
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply