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.
| Author |
Topic |
|
jlbantang
Starting Member
16 Posts |
 Posted - 2007-07-25 : 09:56:49
|
| how to update foreign key field where the primary field is in other database? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-07-25 : 10:25:25
|
what do you mean ? can you show us by example what do you want to do ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-25 : 10:33:22
|
| The value of fkey column should match one in pkey column. |
|
|
|
jlbantang
Starting Member
16 Posts |
Posted - 2007-07-25 : 10:35:56
|
[url=http://www.cjb.net/images.html?a180b.gif] [/url]heres some illustration to get the picture. :Dtnx |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-07-26 : 02:08:26
|
| is it possible to take the relation of two tables which are in different databases?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
jlbantang
Starting Member
16 Posts |
Posted - 2007-07-26 : 05:08:16
|
| no... if it is then i can just use cascade update. |
|
|
|
|
|
|
update error