Why is SQL server throwing this error: Cannot insert the value NULL into column 'id'?
sql, sql-server
Solution
I'm assuming that `id` is supposed to be an incrementing value.
You need to set this, or else if you have a non-nullable column, with no default value, if you provide no value it will error.
To set up auto-increment in SQL Server Management Studio:
- Open your table in `Design`
- Select your column and go to `Column Properties`
- Under `Indentity Specification`, set `(Is Identity)=Yes` and `Indentity Increment=1`
Problem
I'm using the following query: ``` INSERT INTO role (name, created) VALUES ('Content Coordinator', GETDATE()), ('Content Viewer', GETDATE()) ``` However, I'm not specifying the primary key (which is `id`). So my questions is, why is sql server coming back with this error: ``` Msg 515, Level 16, State 2, Line 1 Cannot insert the value NULL into column 'id', table 'CMT_DEV.dbo.role'; column does not allow nulls. INSERT fails. The statement has been terminated. ```