Trigger issue

From: wozi <wozi_at_dhc.net>
Date: Mon, 9 Aug 1999 22:06:12 -0700
Message-ID: <A5EA56F0ED16AECD.53EDBFFF32AA10E6.297DB169E3B81556@lp.airnews.net>

I want some suggestion on creating a trigger for a BEFORE INSERT OR UPDATE ON a table

My table has 3 columns:
col1 col2 col3

Here is the business rule I am trying to enforce during insert or update:

1. If all 3 columns  are null, that's ok. No need for trigger.
2. If all 3 columns are NOT null, that's ok. No no need for trigger.
3. If one column is NOT null, then all 3 columns must be NOT null, then

trigger

    must not permit insert or update.

When replying, please copy tyc77_at_hotmail.com Received on Tue Aug 10 1999 - 00:06:12 CDT