What is difference between nullif and isnull in sql statme
What is difference between nullif and isnull in sql statment?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abhay ShankerPosted Jun 19, 2014, 11:40 PM
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 ( expression , replacement)
Replaces NULL with the specified replacement value. It returns the value of expression if it is not null.