I know about @@IDENTITY and IDENT_CURRENT and SCOPE_IDENTITY in Sql Server but don’t understand the pros and cons attached to each.
Can someone please explain the differences and when I should be using each?
I know about @@IDENTITY and IDENT_CURRENT and SCOPE_IDENTITY in Sql Server but don’t understand the pros and cons attached to each.
Can someone please explain the differences and when I should be using each?