Stored Procedures - Do you use OUTPUT parameters if you need to return the value of variables?
31/12/2019 11:26 AM by
The RETURN statement is meant for returning the execution status only, but not data. If you need to return the value of variables, use OUTPUT parameters. There is a compelling reason for this - if you use return values rather than output values to return data, money values that you return will silently be truncated.
Do you feel this rule needs an update?