title: SQL Insert Into cannot insert NULL
body: <p>I have set some script that inserts data from an XML file into a SQL database.  I am getting the following error.</p>
  
  <pre><code>Cannot insert the value NULL into column 'fighterID', table 'MMA     Database.dbo.FIGHTERStemp'; column does not allow nulls. INSERT fails.
  </code></pre>
  
  <p>I have fighterID set as the primary key and will not allow NULLS.  My intention is to have it number each row as they are inserted.  I found one answer that advises to modify the column properties to be the identifier.  However it will not let me adjust the columns properties without dropping and adding the table again.  </p>
  
  <p>I can do that - but what is the SQL syntax to set the identity specification settings?  Am I going about this the right way?</p>