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
 
Back
Top