title: SQL Server, can't insert null into primary key field?
body: <p>I'm about ready to rip my hair out on this one. I'm fairly new to MS SQL, and haven't seen a similar post anywhere.</p>
  
  <p>When I try to do a statement like this:</p>
  
  <pre><code>INSERT INTO qcRawMatTestCharacteristic 
  VALUES(NULL, 1,1,1,1,1,1,1,'','','', GETDATE(), 1)
  </code></pre>
  
  <p>I get the following:</p>
  
  <blockquote>
    <p>Cannot insert the value NULL into
    column 'iRawMatTestCharacteristicId',
    table
    'Intranet.dbo.qcRawMatTestCharacteristic';
    column does not allow nulls. INSERT
    fails.</p>
  </blockquote>
  
  <p>I understand the error, but the null value is for my my primary field with an int data type.</p>
  
  <p>Any ideas!?</p>