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 April 2, 2025, 11:18 pm This article has been viewed/printed 35306 times. |