How to Pass Null value to user defined table Type parameter in Sql procedure
Hi binustrat,
As far as I think,there are two ways.One is specify a value of DEFAULT in the query string and another way is that you don’t pass in the parameter at all.
More details,you could refer to below article:
https://stackoverflow.com/questions/3630632/binding-empty-list-or-null-value-to-table-valued-parameter-on-a-stored-procedure
Best regards,
Yijing Sun
