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 21, 2024, 12:05 pm This article has been viewed/printed 35229 times. |