>One advise:
>NEVER, NEVER program triggers with assumption that ONLY ONE record will be involved in their action.
>Remember, trigger fires after the whole batch is complete so in your INSERTED and/or DELETED tables you can have many records, not just one.
You are right, I like that in Oracle you can indeed make the trigger fire once for each record if you wish so.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges