title: How can I update multiple XML fields with MSSQL?
body: <p>Table Name  : TBL_CLIENTS
  Table Field : XMLDATA</p>
  
  <pre><code>&lt;REPORT xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" DESCRIPTION="TestClient" FILENUM="1234"&gt;
    &lt;!--&lt;REPORT DESCRIPTION="TestClient" FILENUM="1234"&gt;--&gt;
    &lt;TRACKING&gt;
      &lt;FIRSTNAME&gt;Bobby&lt;/FIRSTNAME&gt;
      &lt;LASTNAME&gt;Butcher&lt;/LASTNAME&gt;
    &lt;/TRACKING&gt;
  &lt;/REPORT&gt;
  </code></pre>
  
  <p>I want to change both the FIRSTNAME and LASTNAME. Is there anyway I can do it in a single query? The only way I can figure it out is using two queries.</p>
  
  <pre><code>UPDATE TBL_CLIENTS
  SET [XMLDATA].modify('replace value of (/REPORT/TRACKING/FIRSTNAME/text())  [1] with ("Franny")')
  WHERE ORDERID = 5
  </code></pre>
  
  <p>and </p>
  
  <pre><code>UPDATE TBL_CLIENTS
  SET [XMLDATA].modify('replace value of (/REPORT/TRACKING/LASTNAME/text())[1]  with ("Farmer")')
  WHERE ORDERID = 5
  </code></pre>