471,338 Members | 1,489 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,338 software developers and data experts.

Passing table to MSSQL stored procedure

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
Jul 21 '05 #1
2 2398
Arrays and Lists in SQL Server
http://www.sommarskog.se/arrays-in-sql.html
AMB
"John Spiegel" wrote:
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

Jul 21 '05 #2
Thanks, Alejandro. Exactly the kind of stuff I was wondering.

- John
"Alejandro Mesa" <Al***********@discussions.microsoft.com> wrote in message
news:EF**********************************@microsof t.com...
Arrays and Lists in SQL Server
http://www.sommarskog.se/arrays-in-sql.html
AMB
"John Spiegel" wrote:
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

Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by dharmadam | last post: by
8 posts views Thread by Yusuf INCEKARA | last post: by
2 posts views Thread by John Spiegel | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.