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-11-09 : 14:30:48
|
| Arpan writes "I have two tables-Users & UsersCopy. The fields in both the tables are excatly the same & so are the datatypes. The tables have the following fields:1. ID int (Primary Key)2. Name varchar(20)3. Email varchar(50)4. UserID varchar(30)5. Password varchar(30)I have created a trigger named 'InsertTrigger' on the 'Users' table which is fired as soon as a new user registers. The users' details are stored in the 'Users' table & since this trigger gets fired, these details are also entered in the 'UsersCopy' table. Now what I want is to create another trigger on 'Users' table which should fire when a user changes his password. Because this trigger gets fired now the change in the 'Password' field in the 'Users' table should also get reflected in the 'UsersCopy' table. How do I do this?" |
|
|
|
|
|
Update Triggers