Passing a null parameter value to a stored procedure
Posted on 2004-03-22
I'm using a TSQLStoredProc to execute a procedure (that I didn't write, and can't modify). I need to be able to pass the first parameter as a null value, because I need the procedure to use the default value for that parameter.
If I just create the parameter, without assigning it a value I get:
No value for parameter "param_name"
when I execute the procedure.
My question is, how do I execute the procedure without getting this error?