Select from following answers:- Vishal
- Null

- visHaL
- None of These.
- All Above
Output will be Null,
As NULLIF Returns a null value if the two specified expressions are equal.
Here,@str1 and @str2 have the same values assigned that is Vishal.NullIf does not check whether expressions are case-sensitive.It checks only expression values.
Here both variables have same values.Therefore it will return Null.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator