allow NULL as input for Stored Procedure parameter

Alan Jiang shared this idea 8 months ago
Idea Logged

Hi Support,

NULL param is unable to pass in to a proc. Hope in next version it can do so. Stmt like this is more often:

WHERE (kClass = @kClass or @kClass is null)

Cheers,

Alan

Comments (1)

photo
1

Hi Alan,

I see what you mean! I have tried this out and I agree with you that a NULL value can't be passed into the stored procedure view.

I have raised an enhancement request based on this Idea and will let you know whether it gets accepted by the product team when they get around to reviewing it.

regards,

David