What is the output of below query?

select isnull('rajesh','sathua');

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

Answer is rajesh.
Actually IsNull checks for 1st expression value,if 1st expression value is null then it return 2nd expression value.

Here,1st expression value is Rajesh and also 1st expression is not null.Then IsNull will return Rajesh.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response

More Interview Questions by Rajesh_Kumar