title: How to insert null value to NOT NULL column using the DEFAULT Constraint
body: <p>These is my <strong>example</strong> table definition:</p>
  
  <pre><code>CREATE TABLE [MyTable] 
  (
      [ColumnName] [bit] NOT NULL
  )
  
  ALTER TABLE [MyTable] ADD DEFAULT ((0)) FOR [ColumnName]
  </code></pre>
  
  <p>I want to be able to pass a <code>Null</code> value to my stored procedure's <code>@ColumnValue</code>, something like:</p>
  
  <pre><code>@ColumnValue = null;
  
  INSERT INTO [MyTable] ([ColumnName])
  VALUES (@ColumnValue)
  </code></pre>
  
  <p>But I'm getting this error: </p>
  
  <blockquote>
    <p>"Cannot insert the value NULL into column... INSERT fails with"</p>
  </blockquote>
  
  <p>Why the <code>DEFAULT</code> constraints not working?</p>