title: Rename XML Node Name in XML column SQL Server using SQL Script
body: <p>I have a Xml Column in a SQL Server 2012 database table called ValidationList. I have a few hundred records in this table. </p>
  
  <p>I have a record like follows </p>
  
  <pre><code>&lt;Configuration xmlns="blah"&gt;
    &lt;CheckTest name="ValidationA"&gt;
      &lt;TestName&gt;NumericTest&lt;/TestName&gt;
    &lt;/CheckTest&gt;
  &lt;/Configuration&gt;
  </code></pre>
  
  <p>I need to Update all the rows and Rename the Node TestName to ValidationName, how can i do this in SQL script?</p>
  
  <p>Thanks</p>