Hi everybody,

I have a stored procedure that updates information in one table and creates new records in a several tables. I would like to return the newly created ID to the caller.

My question is - what is the common practice to return the value - through the Output parameter or through the return value?

Also we do have a generic code to call an SP and return a value, but we don't have generic code to return value through the output parameter.

What do you think?

Thanks in advance.