INPUT type Table

[Frank Dulk]

I would like to know if it is possible the use of parameter INPUT type Table
in SP and to execute her saw application VB with ADO.
Is it also possible to use parameter INPUT array (vector) independent of the
date type and did to execute her see application VB with ADO?
Thank you for the attention.

 

[Aaron [SQL Server MVP]]

No, you cannot use a table type as a parameter.

To simulate an array, see:

http://www.aspfaq.com/2248
http://www.sommarskog.se/arrays-in-sql.html

For other methods of sharing data between stored procedures, see

http://www.sommarskog.se/share_data.html