title: Many Updates -> One Update?
body: <p>Once a month we receive a file from another company and we need to adapt it to our database (in SQL Server). For this we run several updates that take a long time.</p>
  
  <p>Is there any way to "convert" all these updates into a single statement so it runs through the table only once? (it's a really big table!).</p>
  
  <p>We are using something like this right now:</p>
  
  <pre><code>update Table1 set column01 = 0 where column01 = ' ' or column01 = '';
  update Table1 set column02 = 0 where column02 = ' ' or column02 = '';
  update Table1 set column03 = 0 where column03 = ' ' or column03 = '';
  update Table1 set column04 = 0 where column04 = ' ' or column04 = '';
  update Table1 set column05 = 0 where column05 = ' ' or column05 = '';
  update Table1 set column06 = 0 where column06 = ' ' or column06 = '';
  update Table1 set column07 = 0 where column07 = ' ' or column07 = '';
  update Table1 set column08 = 0 where column08 = ' ' or column08 = '';
  update Table1 set column09 = 0 where column09 = ' ' or column09 = '';
  update Table1 set column10 = 0 where column10 = ' ' or column10 = '';
  update Table1 set column11 = 0 where column11 = ' ' or column11 = '';
  update Table1 set column12 = 0 where column12 = ' ' or column12 = '';
  update Table1 set column13 = 0 where column13 = ' ' or column13 = '';
  update Table1 set column14 = 0 where column14 = ' ' or column14 = '';
  update Table1 set column15 = 0 where column15 = ' ' or column15 = '';
  update Table1 set column16 = 0 where column16 = ' ' or column16 = '';
  update Table1 set column17 = 0 where column17 = ' ' or column17 = '';
  update Table1 set column18 = 0 where column18 = ' ' or column18 = '';
  update Table1 set column19 = 0 where column19 = ' ' or column19 = '';
  </code></pre>