>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.

Output parameters because return value can only be numeric.
Cetin