Retrieve new autonumber_ID from stored procedure 1

[dirkg]

Hi,

I have a table which holds a single key ID. ID is an autonumber. I wonder whether it is possible to retrieve the newly assigned ID from a record directly as a return value from the stored procedure I use to append the new record.

Thanks a lot in advance for your help.

Greetz,

Dirk

 

[AWithers]

You need to use the @@IDENTITY feature

e.g in your stored procedure you can set up a return parameter and set it to the value of @@IDENTITY

see BOL for more info

Andy

 

[dirkg]

Thanks Andy, that was indeed what I needed, works perfectly