Stored Procedures - Do you use OUTPUT parameters if you need to return the value of variables?
Updated by ChristianMWaite 5 years ago. See history
123
<introEmbed
body={<>
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.
</>}
/>
Acknowledgements
Related rules
Need help?
SSW Consulting has over 30 years of experience developing awesome software solutions.