|
Posted by John on 08/14/05 15:31
I am hoping to create an updatable view from two tables joined on two
fields. I have two questions;
1. How can I enforce a one to one relation in sql server 2005 based on two
fields? Do I need to create one explicitly under relations? Do I cerate an
index on both fields? Is there a step by step process I can look at to
create one-one relations?
2. Is a view updateable if there is a where clause on one of the fields in
the join/relation?
Thank again.
Regards
Navigation:
[Reply to this message]
|