Re: Unique constraint and NULL values
From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: Fri, 22 Oct 2004 07:20:03 +0100
Message-ID: <p-GdncQOBP0IO-XcRVn-vw_at_giganews.com>
Date: Fri, 22 Oct 2004 07:20:03 +0100
Message-ID: <p-GdncQOBP0IO-XcRVn-vw_at_giganews.com>
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?
--
David Portas
SQL Server MVP
--
Received on Fri Oct 22 2004 - 08:20:03 CEST