Greetings!

I'm relatively new to SQL Server and the concepts of Stored Procedures, and something has baffled me.

When inserting a new record, I sometimes need to know the auto-incrementing Primary Key of the table, say the Transaction Number.

When I call the SQL Execute command from within VB, how can I get values back from the Stored Procedure?

I normally use this method with ADO:

Dim dbMain as ADODB.Connection
dbMain.Open someConnectionString
dbMain.Execute "EXECUTE myStoredProcedure myParameter1"

I am currently using VB6, but may try VB.NET on a new project, if possible,I would definitely appreciate examples for both Ü

Thanks much!