Identity Property Part – 3
This is the third part of this blog series. You can read the 2nd part here Here. In this blog post we’ll learn how to retrieve last generated identity value. There are scenarios where …
Identity Property Part – 3 Read MoreTag: scope_identity
IDENT_CURRENT vs SCOPE_IDENTITY vs @@IDENTITY vs. IDENTITY in SQL Server
These are the most common functions to work with identity values in SQL Server. This blog looks at IDENT_CURRENT vs. SCOPE_IDENTITY vs. @@IDENTITY vs. IDENTITY comparison. Let’s look at the definition …
IDENT_CURRENT vs SCOPE_IDENTITY vs @@IDENTITY vs. IDENTITY in SQL Server Read More