So I'm trying learn SQL using the CBT Nuggets and am at a point where they must have made a mistake because I've gone through and followed everything to a fine detail and they must have left something out.
So I am trying to insert a row into a table and get following IDENTITY_INSERT error:
So I do some research and find out how to turn on the INDENTITY_INSERT as well as identify the column list. After doing so I get a foreign key error as before attempting to enter the row I created a relationship between the 'country' column and the 'country_code'
column from the countries.dbo table. (see below for code).
The error it fully states is:
(0 row(s) affected)
Msg 547, Level 16, State 0, Line 3
The INSERT statement conflicted with the FOREIGN KEY constrai
View Complete Post