title: Updating Xml attributes with new values in a SQL Server 2008 table
body: <p>I have a table in SQL Server 2008 that it has some columns. One of these columns is in Xml format
  and I want to update some attributes.</p>
  
  <p>For example my Xml column's name is <code>XmlText</code> and it's value in 5 first rows is such as:</p>
  
  <pre><code> &lt;Identification Name="John"  Family="Brown"     Age="30" /&gt; 
   &lt;Identification Name="Smith" Family="Johnson"   Age="35" /&gt; 
   &lt;Identification Name="Jessy" Family="Albert"    Age="60" /&gt;
   &lt;Identification Name="Mike"  Family="Brown"     Age="23" /&gt;
   &lt;Identification Name="Sarah" Family="Johnson"   Age="30" /&gt;
  </code></pre>
  
  <p>and I want to change all <code>Age</code> attributes that are 30 to 40 such as below:</p>
  
  <pre><code> &lt;Identification Name="John"  Family="Brown"     Age="40" /&gt; 
   &lt;Identification Name="Smith" Family="Johnson"   Age="35" /&gt; 
   &lt;Identification Name="Jessy" Family="Albert"    Age="60" /&gt;
   &lt;Identification Name="Mike"  Family="Brown"     Age="23" /&gt;
   &lt;Identification Name="Sarah" Family="Johnson"   Age="40" /&gt;
  </code></pre>