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)
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.
Comments have been locked on this page!