>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.
Not sure if this is a generic practice, but I just went with output parameters.
If it's not broken, fix it until it is.
My Blog