Unanswered: SP: Default value for Output parameters
When I call a proc with one input parameter and two output parameters, (all the three parameters having defaults in the proc), I was expecting to see these values defaulted to in the proc. But apparently, this not the case. Could someone tell me what am I doing wrong here? Appreciate your time.
CREATE PROCEDURE dbo.MyTestProc
(@InputParam VARCHAR(30) = 'Input',
@OutPutParam1 VARCHAR(30) = 'OutputParam1' OUTPUT,
@OutPutParam2 VARCHAR(30) = 'OuputParam2' OUTPUT)
SELECT @InputParam, @OutPutParam1, @OutPutParam2
Thanks for your reply. I see that. Is it accurate to say, if I want to get the default values into my calling program's variables, it can be done only by initializing the output parameters in the proc instead of using default values in the signature of the proc?