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-10-14 : 13:01:18
|
| G writes "Hi,I have to update a table(DestinationTable) from another table (OrigniatingTable). Everytime the OriginatingTable changes (gets updated or deleted), I have to updated the DestinationTable with the accurate information because some of my data in the Destination Table might not be good anymore.For this I have created a Trigger onUpdate OriginatingTable and basically what I do is to deletethe contents of DestinationTable and rewrite it with the new data. The only thing is that OriginatingTable is a very big tableand contains huge number amount of records. Is there any otherway of doing it?Or do you have any other suggestions?Thanks!" |
|
|
|
|
|
Triggers