title: Cannot insert the value NULL into column where using Sql Select statement
body: <p>Can you tell me how to avoid below mentioned exception ?</p>
  
  <pre><code> INSERT INTO [Migrated].[dbo].[Cities] (Name, ZipCode)
       SELECT DISTINCT 
           a.City, a.ZipCode 
       FROM
           [Legacy].[dbo].[Ziplist] AS a 
       WHERE
           (a.City IS NOT NULL AND a.ZipCode IS NOT NULL);
  </code></pre>
  
  <p>Exception:</p>
  
  <blockquote>
    <p>Cannot insert the value NULL into column 'IsDeleted', table 'Migrated.dbo.Cities'; column does not allow nulls. INSERT fails.</p>
  </blockquote>