What output below query will return? Select NUllIf(1,1) As a;

 Posted by Rajesh_Kumar on 1/16/2014 | Category: Sql Server Interview questions | Views: 1768 | Points: 40

NULLIF returns Null if the 2 expressions are equal otherwise it returns first argument value.

Here both expressions have same value that is 1.
So NullIf will return Null.So the output will be null.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response