Re: Unique constraint and NULL values

David Portas wrote:
> There is no documented method of making unique constraints ANSI-compliant in
> MS SQL Server 7.0 or 2000. There are some workarounds but no supported
> configuration parameter for changing the unique constraint behaviour.
>
> I would be very surprised if there is such an undocumented feature but if
> you know differently can you post an example or a reference?

I'm not a SQL Server expert but Tom Kyte makes reference to it in Expert One-on-one Oracle. I've loaned my copy of the book to another instructor until he gets his own so I can't quote the page and paragraph.

If Kyte says it is there ... I'm inclined toward believing that it is, indeed, there.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)