getting the result of an SQL INSERT
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.