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
 General SQL Server Forums
 New to SQL Server Programming
 Primary Key Record Inserts

Author  Topic 

gemispence
Yak Posting Veteran

71 Posts

Posted - 2006-02-17 : 10:06:38
I'm performing an insert on a table that has a relationship, but I also want to update the other table that has a foreign key relationship. How do I go about this? Thanks :)

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-17 : 10:24:08
Look for ON UPDATE CASCADE in SQL Server help file


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -