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
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:ON****************@TK2MSFTNGP10.phx.gbl...
Not sure what you want to do. But take a look at Table-valued functions
in SQL Server BOL.
Greg
"John Spiegel" <js******@YETANOTHERSPAMHATERc-comld.com> wrote in message
news:Oz****************@TK2MSFTNGP09.phx.gbl... 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