Look up IDENTITY in Books Online (BOL). You will find that IDENTITY (or
better yet: SCOPE_IDENTITY) will contain the last identity value created IN
THE CURRENT SESSION. Inserts made by users in other sessions will not cause
that value to change.
Jon Davis wrote:
> What if a new INSERT statement excutes in another connection before I
> am able to retrieve the index of the last insert? Is there not a
> synchronous method?