Answers for "The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "". The conflict occurred in database "", table ", column"

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "". The conflict occurred in database "", table ", column

SELECT *
FROM [rpt].ReportLessonCompetency rlc
WHERE NOT EXISTS
(
    SELECT 1 
    FROM [rpt].TraineeGrade tg
    WHERE tg.Id = rlc.Grade
)

Posted by: Guest on February-24-2021

Code answers related to "The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "". The conflict occurred in database "", table ", column"