Passing a set to SQL Server

  • Thread starter Thread starter John Spiegel
  • Start date Start date
J

John Spiegel

Hi all,

Is it possible to pass a DataTable, XML or some other representation of a
set of data to a SQL Server stored procedure? I have some vague
recollection of that being possible but am unsure and can't seem to find
much that tells me either way.

TIA,

John
 
Not sure what you want to do. But take a look at Table-valued functions in
SQL Server BOL.

Greg
 
Hey Greg,

I'm trying to figure out if it's possible to call a stored procedure from a
..NET app and give that procecdure a representation of a table that it could
then use as a cursor or temporary table, perhaps. For example, I have an
app where changes can be made to data that came from a parent table. Based
on the changes, I'd like to send a set of key values to a sproc that
performs the necessary updates to child tables. Since the application
itself doesn't need any of the child data records, it would be nice to not
have to pull them through a data adapter just to alter them and send back.

Thanks,

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Good morning 5
Invalid Column Name Sql-Error :Executing a stored procedure 1
Passing table to MSSQL stored procedure 2
Connecting to Sql Server 2005 2
Passing dates to Sql Server 2005 stored procedure 1
passing Nulls to SQL Server 2005 2
Store XML/XSD in SQL Server 2008 3
record set for pass through query 1

Back
Top