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 - 2004-02-20 : 08:09:26
|
| Tony writes "I wonder if you can answer a trigger problem for me. I need to create a trigger that is activated based on the information of two tables (conditions in two tables must be met) how do i implement a two table trigger. The problem is a need the trigger to update something in table 1 based on conditions in table 1 and table 2 I am using SQL SERVER 2000thank you" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-20 : 09:13:07
|
| A trigger is fires by an action on a single table.You can then check the state of the other table in the trigger.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Multi table triggers