On Monday 14 April 2008 17:44, Andreas Kretschmer wrote:
> Garry Saddington <[EMAIL PROTECTED]> schrieb:
> > How would I write a table check constraint to make sure that two columns
> > don't both have nulls at the same time.
> > The following doesn't do it because it because it does not allow one
Garry Saddington <[EMAIL PROTECTED]> schrieb:
> How would I write a table check constraint to make sure that two columns
> don't
> both have nulls at the same time.
> The following doesn't do it because it because it does not allow one column
> to
> be null while the other holds data?
>
> che
How would I write a table check constraint to make sure that two columns don't
both have nulls at the same time.
The following doesn't do it because it because it does not allow one column to
be null while the other holds data?
check(teachgroup is not null AND set is not null)
regards
garry
--
