Home All Groups Group Topic Archive Search About
Author
9 Jul 2005 10:27 AM
chian
back end i have a table 'temp'. with identity field
in front end i am using datagrid some updation/insertion in my datagrid
my get dataset
ds.getChange()
update records with identity fiedl and
insert records with 'o' value
i wannt to send dataset to xml and then using
xml stored procedure i want to update sotred procedure how?

Author
9 Jul 2005 3:15 PM
Anith Sen
You will have to elaborate your problem so that others can understand your
requirements better. For details see: www.aspfaq.com/5006

In general, you can pass a OPENXML resultset directly to an INSERT statement
like:

EXEC sp_xml_preparedocument @i OUTPUT, @doc
INSERT temp SELECT ....
              FROM OPENXML ( ... ) WITH (.. )
EXEC sp_xml_removedocument @i

--
Anith

AddThis Social Bookmark Button