allow NULL as input for Stored Procedure parameter
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
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
Comments have been locked on this page!