title: Check multiple columns for null in SQL Server 2008
body: <p>Table A:</p>
  
  <pre><code>Id  Name  DateCreated  DateModified
  -----------------------------------
  1    A     2013-1-12    2013-1-15
  2    B     NULL         2013-2-1
  3    C     NULL          NULL
  </code></pre>
  
  <p>I have to migrate this table's data to another table in which <code>DateCreated</code> is a not nullable column, and the conditions are if <code>DateCreated</code> is null use <code>DateModified</code> and if both are null use current date.</p>
  
  <p>I can't use </p>
  
  <pre><code>ISNull(DateCreated,DateModified)
  </code></pre>
  
  <p>because both can be null.</p>
  
  <p>How do I do it? The table has around 10000 rows.</p>