Re: UNIQUE and NULL in SQL
From: Gary Strader <gstrader_at_yahoo.com>
Date: 15 Jan 2002 12:40:03 -0800
Message-ID: <681fb18d.0201151240.4f9e267c_at_posting.google.com>
Date: 15 Jan 2002 12:40:03 -0800
Message-ID: <681fb18d.0201151240.4f9e267c_at_posting.google.com>
brian-l-smith_at_uiowa.edu (Brian Smith) wrote in message news:<60360d48.0112291928.2e7c5818_at_posting.google.com>...
> I want the fourth insert statement above to succeed while still
> enforcing the UNIQUE constraint for non-null columns. Is that
> possible?
Yes - write an insert trigger to check it. And ignore the admonishments as to whether it's "correct" to do so since you probably don't have the luxury to theorize about it. Received on Tue Jan 15 2002 - 21:40:03 CET