[newbie][error] Cannot insert NULL values to identity column

• Jon80

  SSCrazy

  Points: 2598

  More actions

  January 27, 2009 at 8:48 am

  #127126

  I'm trying to pass values within an insert statement, however, I'm not sure what is the best way to pass the most appropriate value to the taskID_PK column bigint identity.

  An insert statement to the table returns the following error:

  Cannot insert the value NULL into column 'taskID_PK', table 'teamwiki.dbo.task'; column does not allow nulls. INSERT fails.\rThe statement has been terminated."

  :w00t:

  VS 2005 / ASP.NET 2.0

  SQL Server 2005 Express

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 27, 2009 at 8:52 am

  #933249

  Just don't specify the identity column in your insert statement.

  
  * Noel