Hi Folks,
My basic requirement is I want to write a trigger on a table based on
certain conditions post-update from another table in another database.
The actors in this scenario are:
Database D1, Table T1
Database D2, Table T2, T3
Action:
T1 updates T2
Requirement:
As soon as T2 is updated, I need to trigger an insert onto T3.
However, I do not want this action to be performed on every update on
T2 (other sources also update T2).
I want the trigger only for updates from T1.
I do not know how to go about it (conditional syntax for the update?)
I urgently require to solve this problem.
Thanks in advance for all those pitching in with help.
Best Regards,
Manoj S. Panicker