title: How to change SQL column value if it is not empty?
body: <p>This is trivially easy when I just need to change one column:</p>
  
  <pre><code>UPDATE [MyTable] SET [MyColumn1] = 'NewValue' WHERE [MyColumn1] &lt;&gt; ''
  ...
  UPDATE [MyTable] SET [MyColumn20] = 'NewValue' WHERE [MyColumn20] &lt;&gt; ''
  </code></pre>
  
  <p>My poblem is, I need to update not just one column, but a dozen. And I'd like to update them all in one UPDATE command instead of firing a separate command for every one. </p>
  
  <p>Is there a way to do this in one update command?</p>