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.