NULL complexities – Part 4, Missing standard unique constraint
SQL Performance
MARCH 11, 2020
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 are not yet available in T-SQL. Nonfiltered unique index. Standard UNIQUE constraint. Unique constraint.
Let's personalize your content