Hi All,
Is there a way to retrieve the value of @@identity global
variable while in a stored proc with no risk of its value
changing due another insert done using same connection?
This is in the context of using auto increment PK in
multiple tables and sharing the JDBC connection between
multiple objects. One which calls a Store Proc and another
which just inserts records.
Thanks,
Bhaskar.