Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 trouble with foreign key conflict

Author  Topic 

b.netana
Starting Member

1 Post

Posted - 2014-06-28 : 21:14:17
Im working on a class assignment that involves inserts however I keep getting foreign key conflict errors with all but one of the entries. They are all structured the same which is what is throwing me off. I am using SQL server 2008, I cannot post the code, but if you are willing to work with me I can email it to you.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-06-30 : 07:46:33
usually when working with foreign keys and inserts, the idea is to insert the independent keys first, followed by their dependents followed by their dependents etc.
Go to Top of Page
   

- Advertisement -