Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What is the output of below query?
declare @str1 varchar(50);
declare @str2 varchar(50);
set @str1 = 'Vishal';
set @str2= 'Kumar';
on 12/31/2013 | Category:
Sql Server Interview questions
| Views: 4249 |
Select from following answers:
None of These.
Output will be Vishal.
As NULLIF Returns a null value if the two specified expressions are equal.But it returns the first expression if the two expressions are not equal.
Here,@str1 and @str2 have the different values assigned that is Vishal and Kumar.
Here both variables have different values.Therefore it will return 1st argument value that is Vishal.
Show Correct Answer
Many Interviews |
< Previous :
What is MVC?
Next > :
What is the output of below sql query? declare ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
What is the output of below sql query? declare @str1 varchar(50); ...
How to give Panel control look as Group box control?
What is the output of below sql query? declare @str varchar(50); s ...
What is the output of below sql query? declare @str varchar(10); s ...
How to check whether CheckBox is checked or not?
How to check all the keys from Session?
Which property of Session ensures that session has been expired?
How to access Session variables in any Class?
Latest Interview Questions
What's the difference between DELETE TABLE and TRUNCATE TABLE com ...
What is a Method Group Conversion in C#?
Tell me about yourself
How to get the list of tables in a database and also the size of which ...
Your developing web application which access data from a MS sql and ha ...
Differences between ISNULL and NULLIF ?
What will be output of following function when called? public strin ...