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-06-22 : 07:35:00
|
| Joel writes "I'd like to use a trigger to cause a record to be inserted into two tables, and to have a separate update trigger move both the record being deleted and the record being inserted to a second table. The secondary tables will be used to track changes to the primary tables. I realize this can be done using other methods, but I'm faced with a pre-existing production database that needs this feature added, and I don't have the luxury of recoding the application." |
|
|
|
|
|
Using a Trigger to Insert to Multiple Tables