title: Bulk update XML records in SQL server
body: <p>I'm trying to update loads of records which are stored as XML in my SQL Server 2008 database similar to this.</p>
  
  <pre><code>&lt;products&gt;
    &lt;product&gt;
      &lt;name&gt;Nike trainer 1&lt;/name&gt;
      &lt;description&gt;Trainer 1&lt;/description&gt;
      &lt;price&gt;10.99&lt;/price&gt;
    &lt;/product&gt;
    &lt;product&gt;
      &lt;name&gt;Nike trainer 2&lt;/name&gt;
      &lt;description&gt;Trainer 2&lt;/description&gt;
      &lt;price&gt;15.99&lt;/price&gt;
    &lt;/product&gt;
    &lt;product&gt;
      &lt;name&gt;Nike trainer 3&lt;/name&gt;
      &lt;description&gt;Trainer 3&lt;/description&gt;
      &lt;price&gt;16.99&lt;/price&gt;
    &lt;/product&gt;
  &lt;/products&gt;
  </code></pre>
  
  <p>I want to bulk update all my prices by 1.50 and as there are approx 900 products this would be very time consuming going through every product, so was wondering if there is a quick way of doing this via SQL statements?</p>