SCOPE_IDENTITY() and @@IDENTITY Demystified
<FONT face=Tahoma>I’ve run across several applications where the use of IDENTITY values has caused some confusion, specifically in how the @@IDENTITY function operates given external influences. We’ve all likely been faced with how to grab the newly generated IDENTITY value from a SQL Server d