>>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
Thank you, Cetin.
If it's not broken, fix it until it is.
My Blog