I have a stored procedure that I am trying to test. I am trying to test it through SQL Management Studio. In order to run this test I enter …
exec my_stored_procedure 'param1Value', 'param2Value'
The final parameter is an output parameter. However, I do not know how to test a stored procedure with output parameters.
How do I run a stored procedure with an output parameter?