Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Unique constraint and NULL values

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@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 - 01:20:03 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US