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.
.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
Member
35 Points
156 Posts
Pass null to user defined Table type parameter to procedure
Jun 27, 2020 06:52 AM|binustrat|LINK
How to Pass Null value to user defined table Type parameter in Sql procedure
Contributor
3730 Points
1412 Posts
Re: Pass null to user defined Table type parameter to procedure
Jun 29, 2020 05:51 AM|yij sun|LINK
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