Hi,
Yep, set a parameter to output like:-
Dim parameterNewid As New SqlParameter("@Newid", SqlDbType.Int)
parameterNewid.Direction = ParameterDirection.Output
command.Parameters.Add(parameterNewid)
you can then call
set @NewID=@@Identity
from the end of your stored procedure.
This brings...