UNIQUE constraint with multiple NULLs

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  December 22, 2002 at 3:10 am

  #444997

  It is just a unique constraint. SQL Server is correct in handling PKs, just as the standard says PKs must not allow NULLs.

  I also thought about (and tried) ANSI_NULLS ON|OFF, but it does not change any of these behaviours.

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Antares686

  SSC Guru

  Points: 125444

  More actions

  December 22, 2002 at 7:18 am

  #444998

  I will test and see what I get here.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 7, 2003 at 4:44 am

  #450515

  See additional comments on similar thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10360&FORUM_ID=9&CAT_ID=1&Topic_Title=clustered+constraint+vs+clustered+index&Forum_Title=General