Copy two xml doc in to a table in sql
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Hi, I have 2 xml documents which contains the data, and I want to read the data from these two xml docs and copy to a table. How to do this, can any one post the syntax. I want to do this in sqlserver. Regards, Kalyan
Kalyan, Try reading through http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=382583&SiteID=1 for how to parse through an xml document and read your elements and attributes. Where the example displays the elements/attributes to a console or listbox, you would have an sql insert statement. Hope this helps. tanya