Viewing 5 posts - 1 through 6 (of 6 total)
Michael L John (3/6/2015)
In the update trigger, delete the rows in the slave tables that match the deleted table, and insert the rows in the slave tables from...
March 6, 2015 at 9:21 am
renato.guiglia (3/6/2015)
First of all, thank you very much for your time! 😉Send Beer.
😀
I recommend a "holding" table. The triggers insert the old and new values into this table, a separate...
March 6, 2015 at 9:06 am
First of all, thank you very much for your time! 😉
yes, one trigger for each operation. It is better to have only one trigger to manage all?
In this case, three...
March 6, 2015 at 4:55 am
I tried your DELETE Script, but it didn't work: i think that you would use DELETED table.
My mistake!
No problem 😉
Your UPDATE script is correct ONLY if you update description field.
If...
March 6, 2015 at 4:05 am
Thank you for your response!
This tables are on two different databases, so we need to keep them in sync.
We cannot change tables structure because there are 3rd party applications that...
March 6, 2015 at 3:02 am
Viewing 5 posts - 1 through 6 (of 6 total)