Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What is the output of value in below query?
declare @value varchar(20);
select coalesce(@value,'vishal') as value;
on 1/14/2014 | Category:
Sql Server Interview questions
| Views: 1742 |
Select from following answers:
command executed successfully
none of these.
Answer would be vishal because coalesce returns 1st non-null column value.and here @value has not been assigned a value,so it will be null.so it coalesce will return 2nd expression value that is vishal.
Show Correct Answer
Many Interviews |
< Previous :
Which method do we use to redirect to user to anot ...
Next > :
What is the output of below query? declare @val ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
What is the output of below query? declare @value varchar(20) = ...
What is a Static class in C#?
What do we mean by Constructor?
Describe the ways of cleaning an objects?
How to get values from Enum?
What is the use of Enums in C#?
What do we mean by Using Keyword?
In what situations Garbage collection can happen?
Latest Interview Questions
What is ViewStart in MVC?
What does Separation of concerns means?
What is MVC?
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 ...