Community

NULL complexities – Part 4, Missing standard unique constraint

(Itzik Ben-Gan) This article is Part 4 in a series about NULL complexities. In the previous articles (Part 1, Part 2, and Part 3), I covered the meaning of the NULL as a marker for a missing value, how NULLs behave in comparisons and in other query elements, and standard NULL handling features that