Hi everyone,

How can I get the results of the last insert. I have a stored procedure that inserts data in a table and I want to get the ID of the inserted data. However, I did not find any documentation that deals with any such SQL function like currval() or something like that.

Any help would be greatly appreciated.

Thanks,
Pankaj

Hi

Assuming ID is an identity then you can use IDENT_CURRENT('table_name')
OR

@@Identity.

Check BOL for further information.

Nickie

Thanks man...@@IDENTITY worked just fine :)

Pankaj