Identity

The @.@.identity return the last inserted value in the database and the
scope_identity return the last inserted value with that scope right ?
No, @.@.IDENTITY returns the last identity value for that session. Check out
BooksOnLine for details.
Andrew J. Kelly SQL MVP
"Joh" <joh@.mailcity.com> wrote in message
news:OfI2v4oRFHA.1396@.TK2MSFTNGP10.phx.gbl...
> The @.@.identity return the last inserted value in the database and the
> scope_identity return the last inserted value with that scope right ?
>