Cannot insert the value NULL into column 'id', table 'XXX'; column does not allow nulls. INSERT fails

Question

I am getting an insert error:

Cannot insert the value NULL into column 'id', table 'db.dbo.table'; column does not allow nulls. INSERT fails

.

I have checked the data and the column I am inserting into 'id' does not have any nulls. Any suggestions?

Answer 1

The error

column does not allow nulls

is happening because you are trying to insert data which has NULL for the column id, for at least one record which you are trying to insert. It has nothing to do with the state of the column before you attempted the insert. Check the source of your insertion data and remove/replace the NULL values, or alter the id column to accept NULL.