General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only