Got a best practices question....
I often have to write PROCEDURES that return a value (because it needs
to have a transaction in it)...and I can't do that in a FUNCTION.
CREATE PROCEDURE `sp_test01`()
-- Do some insert
This makes it very easy to get a return value from the CALL sp_test01()
from, for example, C#....set it up.....ExecuteScalar.
However, it doesn't allow me to call this and get a return value from
within another PROCEDURE.
CALL sp_test01() INTO var_X;
now I know I can use an OUT parameter for ...