Pass Default value to Table Valued parameter - SQL Server

Viewed 15115

I am using a table-valued parameter in one our stored procedures. Here is the syntax I used:

@districtlist NumericList readonly

(NumericList is the user-defined table type).

However, as a requirement I need to pass default values to this table valued parameter.

@districtlist NumericList = 0 readonly

But above code throws a syntax error. Is it possible to pass default value to a table valued parameter? Could someone help me on this?

2 Answers
Related