Maharudra Gadekar

Maharudra Gadekar

  • 1.3k
  • 338
  • 76.2k

How to get child node value in xml in sql server?

Feb 22 2022 9:34 AM

Hi All,

I want to get child node value which is stored in database in xml format node is below like that.

<Main>  

<field Dates="01/03/2022">
    <structure dataType="DateTime" culture="en-GB" checkedValues="" />
    <fn>dates</fn>
    <fv id="date">2022-03-01</fv>
  </field>

</Main>

 

so above is my sql server value in xml format and I want the value from FV node, but in xml no of FV node is present in XML. So please help me

 

thank in advance!

 


Answers (3)