How to get data from XML and send it into table

Question

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.
		

Answer 1

you can get reference  from bellow link , i hope it's link few useful for you.


http://msdn.microsoft.com/en-us/library/ms747393(v=vs.110).aspx