Re: Multiple Triggers of Same Type on Same Table?

"Advo" <x_at_x.com> wrote in message
news:UsTeg.5329$C9.3954_at_newsfe4-win.ntli.net...
:I have just been looking into triggers, and how that having multiple
: triggers of the same type, on the same table is allowed (but isnt ideal
: at all, because of the fact the order they fire in is random..)
:
: so, why is it allowed in like Standard SQL?
:
: I can't find an actual reason, other than the fact that it is because of
: market pressure from 3rd party developers.. but any other actual reasons
: for this?
:
: Thanks

your observation that it isn't ideal only applies if the order of execution is important

++ mcs Received on Tue May 30 2006 - 04:47:50 CDT