Showing posts with label Difference between NULLIF and ISNULL. Show all posts
Showing posts with label Difference between NULLIF and ISNULL. Show all posts

Friday, 13 May 2016

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.