Viewing 2 posts - 1 through 2 (of 2 total)
The table hints XLOCK is a solution
see book online for more info.
October 22, 2003 at 12:11 pm
#479158
use system variable @@IDENTITY
Returns the last-inserted identity value.
Return Types
numeric
After an INSERT, SELECT INTO, or bulk copy statement completes, @@IDENTITY contains the last identity value generated by the statement....
May 8, 2002 at 10:55 am
#428729