Msg 547, Level 16, State 0, Line 1
The INSERT statement conflicted with the FOREIGN KEY constraint “foreignKey_child”. The conflict occurred in database “jugal_1”, table “dbo.parent”, column ‘parentid’.
The statement has been terminated.
Solution: Error message is pretty clear, it means the value you are inserting into child table is not exist in the parent table. There could be number of reason for i.e value not exist in parnet table, you have added value in the table but yet it is not commited, you are updating the foreign key column.
Script to reproduce issue
create table parent
parentid int constraint primaryKey_parent primary key,
create table child
childid int constraint foreignKey_child foreign key references parent(parentid),
insert into child values(10,’jugal’)