Difference between NULLIF and ISNULL

NULLIF:

NULLIF( expression , expression)

It returns a null value if both the expression is equal. NULLIF returns the first expression if both the expression is not equal.

 ISNULL:

ISNULL ( expression , replacement)

Replaces NULL with the specified replacement value. It returns the value of expression if it is not null.

 

Ebook Download
View all
Learn
View all