Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Foreign key constraint
Message
From
13/09/2011 11:17:32
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01523430
Message ID:
01523434
Views:
33
>>HI
>>
>>I'm inserting records into several tables.
>>
>>I've wrapped all the inserts in a transaction as I don't want any of them to work if one fails.
>>
>>I'm getting a foreign key error on one of the inserts.
>>
>>Is this because the transaction hasn't been committed so effectively the foreign key doesn't exist
>>
>>Thanks
>>
>>Nick
>
>No, this is not because of this problem. You probably didn't insert records in the right order.

Thanks for that Naomi.

Made me look back at the obvious

a typo :-(
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform