Question: what is the difference between isnull () and nullif() function?
Answer: SQL SERVER – Explanation and Comparison of NULLIF and ISNULL. Returns a null value if the two specified expressions are equal. ... NULLIF is equivalent to a searched CASE function in which the two expressions are equal and the resulting expression is NULL.