title: SQL UPDATE: Multiple columns in one statement or multiple single-column statements?
body: <p>Is it more efficient to execute one <code>UPDATE</code> statement with multiple columns</p>
  
  <pre><code>UPDATE myTable 
  SET [col1] = [col1] + 1, 
  [col2] = [col2] + 1,
  [col3] = [col3] + 1,
  ... 
  [colN] = [colN] + 1
  </code></pre>
  
  <p>or multiple <code>UPDATE</code> statements with a single column each?</p>
  
  <pre><code>UPDATE myTable SET [col1] = [col1] + 1
  UPDATE myTable SET [col2] = [col2] + 1
  UPDATE myTable SET [col3] = [col3] + 1
  ...
  UPDATE myTable SET [colN] = [colN] + 1
  </code></pre>