SQL Server Insert Null error in spite of providing not null values

Question

I am trying to do an insert but it is giving an error stating that credits cannot be null but I am not providing null. Attached Screenshot

Code: Insert into [dbo].[Course] values (12,'Java',1,1,1);

Error: Msg 515, Level 16, State 2, Procedure trgAfterInsert, Line 31 Cannot insert the value NULL into column 'Credits', table 'DemoCollege.dbo.Course'; column does not allow nulls. INSERT fails. The statement has been terminated.

Trigger:

Create trigger trgAfterInsert2 ON [dbo].[Course]
After Insert
AS 
Declare @cid int;
Declare @cname nvarchar(50);



Select @cid = i.CourseID from inserted i;
Select @cname = i.Title from inserted i;


Insert into dbo.CourseTemp values (@cid, @cname);

Print 'After insert trigger fired';
GO

And please note that your trigger does not support multiple row inserts. — IVNSTN
– IVNSTN, Commented Mar 4, 2016 at 18:12
There's no way that trigger generates the error you're getting. Please post the actual one. — Gareth Lyons
– Gareth Lyons, Commented Mar 4, 2016 at 19:38

Gareth Lyons · Accepted Answer · 2016-03-04 17:20:38Z

2

There's an insert trigger on the table & that's where the error is being generated from. There must be some logic in that is converting the provided credit value to a null value somehow.

answered Mar 4, 2016 at 17:20

Gareth Lyons

1,97214 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Oscar · Accepted Answer · 2016-03-04 17:20:59Z

1

Just provide the columns where you want to insert the values.

 Insert into [dbo].[Course](ColName1, ColName2, ColName3, ColName4, etc..) values (12,'Java',1,1,1);

Most probably you're missing a col in the middle

answered Mar 4, 2016 at 17:20

Oscar

14.1k9 gold badges53 silver badges84 bronze badges

1 Comment

Gareth Lyons Over a year ago

Good advice to provide column list, but it's not the problem here.

Collectives™ on Stack Overflow

SQL Server Insert Null error in spite of providing not null values

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related