It is a common business case to have to reuse the auto-generated SQL Server’s IDENTITY value. One way to deal with the problem is to use the system function @@IDENTITY. For example:
Posts Tagged ‘OUTPUT’
May 6, 2011 by Francois · Leave a Comment
Filed under: TSQL
Social Tagging: @@IDENTITY • bug • INSERT • OUTPUT • SCOPE_IDENTITY() • sql • sql server • TSQL
Filed under: TSQL
Social Tagging: @@IDENTITY • bug • INSERT • OUTPUT • SCOPE_IDENTITY() • sql • sql server • TSQL
RSS