SQL Server – Execute Stored Procedure with Output Parameter?
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?