Is there any way to specify a table valued parameter using the built-in SQL Management Studio IDE for executing a stored procedure? When the screen comes up, the table-valued parameter is listed with appropriate user-defined TableType... however, I'm not quite sure how to specify the data I wish to pass in the "Value" column. Passing null causes an "Operand type clash: void type is incompatible with CustomTypeName" error
As far as I know, you cannot do this. There is no literal representation for a whole table - which is what is required for each non-nullable parameter in that menu.
If there is a clever way to make it happen, I don't know what it is.
table valued parameters in IDE
Posted - 12/06/2012 : 09:35:31
