Hi!
I have a stored procedure that will insert a new record into a table. It has an id that the identity an therefore assigned a value by SQLServer automatically at insert.
My problem is that I would like to return that id to my application as soon as the insert is done. How can I do that? The input parameters are not unique so I don´t want to use them as search objects...

Code snippet:

CREATE PROCEDURE stAddNewBP

@name as varchar,
@des as varchar

AS

insert into tbBP
(tbName,tbDescription)
values(@name,@des)

How can I select/return the new ID from this? Please help me. Using SQL Server 7.0 and VB 6.0.
Jenny