Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What is the output of below sql query?
declare @str1 varchar(50);
declare @str2 varchar(50);
set @str1 = 'Vishal';
set @str2= 'visHaL';
on 12/31/2013 | Category:
Sql Server Interview questions
| Views: 3644 |
Select from following answers:
None of These.
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
Many Interviews |
< Previous :
What is the output of below query? declare @str ...
Next > :
How to give Panel control look as Group box contro ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
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?
Which Sql statement is used for returning unique rows?
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 ...