i have xml data as one of the columns in database. I have to extract the columns ( i have more than 4 nodes in xml) from xml and insert into another table.
I am new to XML .I googled and found many examples extracting data from xml file.But in my case it is from a data base table.
Please let me know how can i accomplish this task.
pinky1234
Member
2 Points
3 Posts
extract data from xml which is pulled from database
Apr 28, 2012 08:51 PM|LINK
Hi ,
i have xml data as one of the columns in database. I have to extract the columns ( i have more than 4 nodes in xml) from xml and insert into another table.
I am new to XML .I googled and found many examples extracting data from xml file.But in my case it is from a data base table.
Please let me know how can i accomplish this task.
THanks in advance..!
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: extract data from xml which is pulled from database
Apr 30, 2012 01:21 AM|LINK
Hello：）
What do you mean by this？
What structures of DataTables have you got now？