Mitsuda, Alex writes: > Need to be a bit careful though, if there are "simultaneous" inserts going > on @@identity is not guaranteed to give back the correct key...besides a > numeric primary key, it's always good practice to have an alternate primary > key with which you can check against...
@@identity will be the latest insert on this particular connection. Simultaneous inserts on a different connection do not affect it. Michael -- Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler [EMAIL PROTECTED] - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com
