Download
100% FREE
Office Document APIs for .NET
Online: 599
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
What output below query will return? Select NUllIf(1,1) As a;
Posted by
Rajesh_Kumar
on 1/16/2014 | Category:
Sql Server Interview questions
| Views: 1272 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Answer:
NULLIF returns Null if the 2 expressions are equal otherwise it returns first argument value.
Here both expressions have same value that is 1.
So NullIf will return Null.So the output will be null.
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
What is the work of GC?
Next > :
Select ifnull(10,20) What will be the output?
Comments or Responses
Login to post response
More Interview Questions by Rajesh_Kumar
Select ifnull(10,20) What will be the output?
What is the output of below query? select isnull('rajesh',& ...
Latest Interview Questions
What are the responsibilities of transport layer?
What is the role played by physical layer?
Which of the following statement is correct with respect to the below ...
Which of the following is true with respect to inheritance mechanism? ...
Which of the following is correct about data types? 1.If the integer ...
Which of the following statement is correct? 1.The signature of an in ...
Output for the following code? namespace IndiabixConsoleApplication ...
How many times can a constructor be called during the life time of an ...
More ...