What is the use of nullif function?

 Posted by Kmandapalli on 1/20/2014 | Category: Sql Server Interview questions | Views: 3252 | Points: 40
Answer:

Nullif function contains two parameters.
It returns null values when two expressions are equal, returns the first parameter if not equal.
Eg:
If the first parameter is dotnet and second also dotnet, then the result will be null.
If the first parameter is dotnet and second is funda, then the result will be dotnet.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response