What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
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? … Read more