I know Scope_Identity(), Identity(), @@Identity, and Ident_Current() all get the value of the identity column, but I would love to know the difference.
Part of the controversy I’m having is what do they mean by scope as applied to these functions above?
I would also love a simple example of different scenarios of using them?
