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 29, 2024, 1:51 pm This article has been viewed/printed 35113 times. |