How many null value a unique key constraint can have?

I think there can be only one null value for a unique key constraint but some say there can be more than one null value.
  • Interview Candidate
  • 3
  • 7635

Showing Answers 1 - 3 of 3 Answers

jamesravid

  • Jul 18th, 2007
 

There is no such limit. you unique column have any number of null values.

The basic reason is NULL not equal to NULL (like inifinity <> infinity).

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions