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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-26 : 16:33:24
|
| Tony writes "Please can anyone show me the most efficient way of inserting values into foreign key column(s)? For example, if a value is chosen in a parent table, i.e 2 - Jasper. And Jasper(2) has placed two orders, which mean 2 appears twice in the FK column of the order table. How can I insert these values? Should I use a store procedure or a trigger? If so how?I need help.ThanksT" |
|
|
|
|
|
Foreign Key insertion