Provide Required Values for NOT NULL Columns

To resolve a constraint violation caused by missing data in mandatory columns, follow these steps:

1. Execute sp_help 'schema_name.table_name' to retrieve the table definition and identify columns where the 'Nullable' property is set to 'no'.
2. Review your INSERT statement to ensure that every column identified as 'no' for nullability is included in the column list, unless the column has a defined DEFAULT constraint.
3. Update the VALUES clause to include a valid, non-null value for each mandatory column identified in the previous step.
4. Re-execute the INSERT statement to verify that the database engine accepts the data and completes the transaction successfully.

Sources