On many occasions rows may be inserted utilizing an identity column as the primary key, in many of these cases it may be necessary to capture the newly auto-generated value. The following article will describe three such approaches: @@IDENTITY, SCOPE_IDENTITY(), and IDENT_CURRENT().

[Read more...]