Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akashenk
Posting Yak Master
111 Posts |
 Posted - 2012-12-06 : 09:35:31
|
| 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 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-12-06 : 10:01:07
|
| 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. |
 |
|
|
akashenk
Posting Yak Master
111 Posts |
Posted - 2012-12-06 : 11:31:24
|
| ok... thanks. |
|
|
|
|
|
|
table valued parameters in IDE