title: how to update multiple xml node values through a single query
body: <p>consider the xml </p>
  
  <pre><code>&lt;root&gt;
    &lt;parent id="1"&gt;
      &lt;child&gt;
        &lt;field name="1"&gt;
          &lt;value&gt;abc&lt;/value&gt;
        &lt;/field&gt;
        &lt;field name="2"&gt;
          &lt;value&gt;cdf&lt;/value&gt;
        &lt;/field&gt;
        &lt;field name="2"&gt;
          &lt;value&gt;xyz&lt;/value&gt;
        &lt;/field&gt;
        &lt;field name="1"&gt;
           &lt;value&gt;uvw&lt;/value&gt;
        &lt;/field&gt;
      &lt;/child&gt;
    &lt;/parent&gt;
    &lt;parent id="2"&gt;
      &lt;child&gt;
        &lt;field name="1"&gt;
          &lt;value&gt;123&lt;/value&gt;
        &lt;/field&gt;
        &lt;field name="3"&gt;
          &lt;value&gt;234&lt;/value&gt;
        &lt;/field&gt;
        &lt;field name="4"&gt;
          &lt;value&gt;34&lt;/value&gt;
        &lt;/field&gt;
        &lt;field name="1"&gt;
          &lt;value&gt;544&lt;/value&gt;
        &lt;/field&gt;
     &lt;/child&gt;
   &lt;/parent&gt;
  </code></pre>
  
  <p></p>
  
  <p>i want to update the text value of 'value' where 'name' attribute of field node is equal to '1'</p>
  
  <p>here is what i have right now....</p>
  
  <pre><code>update newTable
  set xmlcol.modify('replace value of(/root/parent/child/field[@name="1"]/value/text()) with "newValue"')
  </code></pre>
  
  <p>will this work for all occurrence or just first one???</p>