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

Forum statistics

Threads
473,996
Messages
2,570,238
Members
46,826
Latest member
robinsontor

Latest Threads

Top