What is the output of below query?

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

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.