title: Find count of null/empty records for all the columns
body: <p>I have a table with 40 columns in it.</p>
  
  <p>I wish to write a query which will return to me the number of null/empty values in each column.</p>
  
  <p>Example,</p>
  
  <p>If there are Columns A, B, C and D.</p>
  
  <p>My output desired is:</p>
  
  <pre><code> A|B|C|D
   3|5|4|9
  </code></pre>
  
  <p>Where 3 is the number of records:
      where A is null or A = ''
  and so on...</p>
  
  <p>Any help would be appreciated.
  I'm using MS SQL 2008 R2</p>