rachit sharma

rachit sharma

  • NA
  • 16
  • 13.5k

How to get data from XML and send it into table

Aug 26 2013 10:35 PM
Want to get values Coming in XML format using stored procedure. The values i am getting are like in the format as mentioned below . What i am trying to do is to just create a table in database as 'RecordsDB' and using Stored procedure parsing the XML, inserts the value in 'Records'. I am trying to search question like this on stack overflow and net but not getting answer ,only knows the mini way is to read the node value like line.column.value(something). But i do have some thousands of records coming from ASP.NET web service.*

  <Root>                        (Root node)
       <Record>                    (Secondary node)
         <Name> A </Name>           (Child node1)
          <Age> 21 </Age>            (Child node2)
       </Record>
         <Record>
         <Name> b </Name>
          <Age> 22 </Age>
       </Record>
      </Root>

How to meet the task? Thanks.


Answers (3)