title: Why is SQL server throwing this error: Cannot insert the value NULL into column 'id'?
body: <p>I'm using the following query:</p>
  
  <pre><code>INSERT INTO role (name, created) VALUES ('Content Coordinator', GETDATE()), ('Content Viewer', GETDATE())
  </code></pre>
  
  <p>However, I'm not specifying the primary key (which is <code>id</code>).  So my questions is, why is sql server coming back with this error: </p>
  
  <pre><code>Msg 515, Level 16, State 2, Line 1
  Cannot insert the value NULL into column 'id', table 'CMT_DEV.dbo.role'; column does not allow nulls. INSERT fails.
  The statement has been terminated.
  </code></pre>