Stored Procedures - Do you use OUTPUT parameters if you need to return the value of variables?
  v2.0 Posted at 31/12/2019 11:26 AM by Christian Morford-Waite

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

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address: