On 27 jun, 16:29, mdipierro <mdipie...@cs.depaul.edu> wrote: > Anybody opposed to this change? > > Massimo > Me I correct myself, I said before that SCOPE_IDENTITY () not working, but I had a typo.
I think SCOPE_IDENTITY () is the right choice, because IDENT_CURRENT is out of session. SCOPE_IDENTITY () works correctly. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - IDENT_CURRENT returns the last identity value generated for a specific table in any session and any scope. @@IDENTITY returns the last identity value generated for any table in the current session, across all scopes. SCOPE_IDENTITY returns the last identity value generated for any table in the current session and the current scope.
