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 |
|
aldo007
Starting Member
2 Posts |
 Posted - 2010-08-09 : 15:41:23
|
| Hi everyoneI need some help with a one to one relationship.I have 2 tables related with one to one relationship.Does this mean that if I insert a new row to one table that will in automatically add one row with the same id to the other table????thnx in advanced aldi |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-09 : 16:25:19
|
| No. You have to explicitly insert data into both tables. |
 |
|
|
aldo007
Starting Member
2 Posts |
Posted - 2010-08-09 : 18:37:28
|
quote:
Originally posted by robvolk
No. You have to explicitly insert data into both tables.
thanke you  |
|
|
|
Laith Scofield
Starting Member
10 Posts |
Posted - 2010-08-09 : 18:38:39
|
| yes that's rightyou have to insert data in both tables not in one...."It's fine to celebrate success but it is more important to heed the lessons of failure."Bill Gates |
|
|
|
|
|
|
one to one relationship