Lets suppose, you have created the following table in SQL SERVER 2014.
Create TABLE Testable
(Id INT PRIMARY KEY NOT NULL,
Name Varchar(10) NOT NULL,
Status INT NOT NULL)
There can be many ways to insert new records into “Testable” by using below statements.
Way 1:
INSERT INTO Testable (ID,NAME) VALUES (1,'ANNY')
INSERT INTO Testable (ID,NAME) VALUES (2,'Ashlee')
But getting the below error.
Msg 515, Level 16, State 2, Line 6
Cannot insert the value NULL into column 'Status', table 'TestDB.dbo.Testable'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Way 2:
INSERT INTO Testable(ID,NAME,Status) VALUES (1,'ANNY',NULL)
But getting the below error.
Msg 515, Level 16, State 2, Line 6
Cannot insert the value NULL into column 'Status', table 'TestDB.dbo.Testable'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Causes :
You are trying to insert new records into table and values for some columns assigned as “NULL” but used NOT NULL Constraints for Columns at time of creating table.
Solution of the Error :
Assign values to columns when inserting new records into table, if you have applied NOT NULL constraints for columns.
INSERT INTO Testable(ID,NAME,Status) VALUES (1,'ANNY',0)
INSERT INTO Testable(ID,NAME,Status) VALUES (2,'Ashlee',1)
Output :
Id Name Status
1 ANNY 0
2 Ashlee 1
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.