Passing table to MSSQL stored procedure

[John Spiegel]

Hi all,

Any suggestions on the best way to pass a set of values to a stored
procedure that will use them in a query? Specifically, I want to call a
stored procedure from .NET that takes a set of phone numbers and returns a
resultset of records containing these numbers from a table. Is it possible
to pass a dataset/XML or something that would be interpreted as a table? Or
do I need to pass a string and convert it to a temporary table in the stored
procedure? Or...?

TIA,

John

 

[Guest]

Arrays and Lists in SQL Server
http://www.sommarskog.se/arrays-in-sql.html


AMB

 

[John Spiegel]

Thanks, Alejandro. Exactly the kind of stuff I was wondering.

- John