Par2: Getting MS SQL identity value 2009-08-20 -- Mark Riffey The /autoinc option below returns the autoinc value to you in your sysid field. I suggest using the other options as well, but your mileage may vary. /BUSYRETRIES=200 /MULTIPLEACTIVERESULTSETS=TRUE /BUSYHANDLING =2 /AUTOINC=Select @@IDENTITY Printed November 23, 2024, 2:22 am This article has been viewed/printed 35232 times. |