SQL-How to Insert Row Without Auto incrementing a ID Column?

In addition to Charles' answer (which is now 100% correct :-) and which preserves the current value of the IDENTITY on the table), you might also want to check the current value of an IDENTITY on a table - you can do this with this command here:

DBCC CHECKIDENT('YourTableName')

If you ever need to actually change it, you can do so by using this command here:

DBCC CHECKIDENT ('YourTableName', RESEED, (new value for IDENTITY) )

If you are in Microsoft SQL Server, you can "turn off" the autoIncrementing feature by issuing the statement Set Identity_Insert [TableName] On, as in:

  Set Identity_Insert [TableName] On
  -- --------------------------------------------
  Insert TableName (pkCol, [OtherColumns])
  Values(pkValue, [OtherValues])
  -- ---- Don't forget to turn it back off ------
  Set Identity_Insert [TableName] Off