Is two NULL Value's are equal??

  • If two NULL value's are different then why we cant insert two null values in Unique constraint column. Please anyone can explain this??

    Thanks

  • In Unique Key consraint only one null value is allowed......

  • I agree that there are some inconsistencies about NULL values, but maybe you will understand it better if you look at it from another side. Two NULL values are not equal, but also they are not different - they are simply unknown. Unique constraint makes sure that any two values in the column are different.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply