title: how to update element name in a xml column in sql server
body: <p>I have an xml column in my table like following:</p>
  
  <pre><code>   &lt;info&gt;
        &lt;teacher&gt;     
              &lt;name&gt;John&lt;/name&gt;   
        &lt;/teacher&gt;
        &lt;StInfo&gt;
          &lt;name&gt;William&lt;/name&gt;    
          &lt;address&gt;India&lt;/address&gt;    
        &lt;/StInfo&gt;
      &lt;/info&gt;
  </code></pre>
  
  <p>I have to just update  to </p>
  
  <pre><code> &lt;info&gt;
            &lt;teacher&gt;     
                  &lt;name&gt;John&lt;/name&gt;   
            &lt;/teacher&gt;
            &lt;Student&gt;
              &lt;name&gt;William&lt;/name&gt;    
              &lt;address&gt;India&lt;/address&gt;    
            &lt;/Student&gt;
          &lt;/info&gt;
  </code></pre>