Best Online Tutorials

SQL Tutorial

Free SQL Tutorial

SQL Interview Questions

SQL Practice Questions

SQL Tips & Tricks

SQL Errors

SQL Books

Angular Tutorial

Free Angular Tutorial

Angular Interview Questions

Angular Practice Questions

Angular Tips & Tricks

Angular Errors

Angular Books

Node.js Tutorial

Free Node.js Tutorial

Node.js Interview Questions

Node.js Practice Questions

Node.js Tips & Tricks

Node.js Errors

Node.js Books

React.js Tutorial

Free React.js Tutorial

React.js Interview Questions

React.js Practice Questions

React.js Tips & Tricks

React.js Errors

React.js Books

SSIS Tutorial

Free SSIS Tutorial

SSIS Interview Questions

SSIS Practice Questions

SSIS Tips & Tricks

SSIS Errors

SSIS Books

SEO Tutorial

Free SEO Tutorial

SEO Interview Questions

SEO Practice Questions

SEO Tips & Tricks

SEO Errors

SEO Books

Javascript Tutorial

Free Javascript Tutorial

Javascript Interview Questions

Javascript Practice Questions

Javascript Tips & Tricks

Javascript Errors

Javascript Books

MongoDB Tutorial

Free MongoDB Tutorial

MongoDB Interview Questions

MongoDB Practice Questions

MongoDB Tips & Tricks

MongoDB Errors

MongoDB Books

Next.js Tutorial

Free Next.js Tutorial

Next.js Interview Questions

Next.js Practice Questions

Next.js Tips & Tricks

Next.js Errors

Next.js Books

ERROR (Msg 515): Cannot insert the value NULL into column 'Column Name', table 'Table Name'; column does not allow nulls. INSERT fails. 

Pooja Goel  |   Dec 15, 2019  |  Views: 140

Description:

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

 


Comments:
Content Contributor
Pooja Goel

Pooja Goel

Sr. Software developer at Damco Solutions Pvt. Ltd.  |   Noida, Uttar Pradesh, India

I am a sr. software developer working on technologies like SQL, SSIS, SSRS, DB2,Tableau, ASP.NET having 7 years of experience.


Read related articles

Want to sell your software ?-

If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.

  • Sell ERP
  • Sell Website Clones
  • Sell App Clones
  • Sell Readymade Portals
  • Sell Readymade Websites
  • Sell Mobile Apps
  • Sell Window Apps

Clients will find it using our advanced search filter and will contact you directly.

No any charge for the product lsiting.

Do you own a Company ?+

Property.sale

Buy or Sell Commercial Property+

Are you a freelancer ?+

Looking for a job ?+

Are you a Service Provider ?+

Are you a blogger ?+

Do you own an IT Institute ?+



Property.sale