SQL SERVER – Explanation and Comparison of NULLIF and ISNULL | Journey to SQL Authority with Pinal Dave

Explanation of NULLIF Syntax: NULLIF ( expression , expression ) Returns a null value if the two specified expressions are equal. NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression. NULLIF is equivalent to a… Continue Reading...

Source: SQL SERVER – Explanation and Comparison of NULLIF and ISNULL | Journey to SQL Authority with Pinal Dave