Re: [SQL] CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER

2002-12-16 Thread Michael Paesold
Ludwig Lim <[EMAIL PROTECTED]> wrote: >I am just wondering. Which one is executed first: > CHECK Constraints or BEFORE INSERT OR UPDATE TRIGGER? First the BEFORE... TRIGGERs, then the CHECK contraints, so you definetly can change a row in a trigger to match the contraints... Regards, Michael

[SQL] CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER

2002-12-16 Thread Ludwig Lim
Hi: I am just wondering. Which one is executed first: CHECK Constraints or BEFORE INSERT OR UPDATE TRIGGER? Thank you very much, ludwig. __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -