Stored Procedures - Do you use OUTPUT parameters if you need to return the value of variables?

Last updated by ChristianMWaite over 4 years ago.See history

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.

Adam Cogan
We open source. Powered by GitHub