SCOPE_IDENTITY

• 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

  More actions

  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

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter