title: Update Single XML Node Value of XML Column using SQL Server
body: <p>I want to update single value of XML Node in SQl Server</p>
  
  <p>Below is the table structure</p>
  
  <p><a href="https://i.stack.imgur.com/3IgXW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3IgXW.png" alt="enter image description here"></a></p>
  
  <p>XML Structure</p>
  
  <pre><code>&lt;PayDetails&gt;
    &lt;Column Name="FG" DataType="float" Value="7241" /&gt;
    &lt;Column Name="SKILL" DataType="float" Value="3" /&gt;
    &lt;Column Name="PI" DataType="float" Value="87" /&gt;
    &lt;Column Name="MD" DataType="float" Value="30" /&gt;
    &lt;Column Name="LD" DataType="float" Value="4" /&gt;
    &lt;Column Name="WEEKOFF_DAYS" DataType="float" Value="4" /&gt;   
    &lt;Column Name="NETPAY" DataType="float" Value="5389" /&gt;    
  &lt;/PayDetails&gt;
  </code></pre>
  
  <p>I want to update value of <strong>FG</strong> from 7241 to 8000</p>