Error: Cannot insert the value NULL into column 'ID', table 'Table name' column does not allow nulls. INSERT fails. The statement has been terminated

Help Studio
,
1

Execute Query:
“INSERT Into [Table_name]
Default VALUES
SELECT SCOPE_IDENTITY()”
I have this in one project and its working and creating an empty row in table.

BUT on other project it’s not working and giving this Error everything is same in table but just 2 different table.
can someone tell why?

2

Hi @Ellen

One of these might be the case of the error that you are getting:

  1. There might be differences in the data you are trying to insert. Make sure that you are not explicitly specifying the ‘ID’ column or that you are providing valid values for the ‘ID’ column in both projects.
  2. Ensure that the table schema (e.g., column names, data types, constraints) is the same in both projects. Any differences in the table schema could result in this error.

Hope this helps,
Best Regards.