Importing XML into SQL Server DB

G

Guest

I'm exporting a table from SQL DB (Server 1)into xml file as following :-
I have strored procedure that select all data in table where the ID = (say
134)
then filling the dataset and write to a file.(we called it exporting phase)
we move the file to other server and then did changes in xml data ...and now
we need to import xml data into the DB Table which has identical schema of
exported table
what is the way to export the XML data into the table?
 

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

Members online

No members online now.

Forum statistics

Threads
473,770
Messages
2,569,583
Members
45,073
Latest member
DarinCeden

Latest Threads

Top