sqlrambling.net
The Joys of @@IDENTITY, Scope_Identity and IDENT_CURRENT
For several years I have happily relied on @@IDENTITY to return the latest identity of a row when inserting data. However, I have started using the OUTPUT clause and have discovered the entertainme…