Write and justify output of - select nullif('test','test')

Posted by Bhakti on 11/24/2009 | Category: Sql Server Interview questions | Views: 5164

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

The output will be – NULL
Justificatio n : nullif returns NULl if given two arguments are same else returns the first specified argument. So, for the given SQL, output will be NULL.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to get date of 234 days back in SQL?

Next > : Return type of RAND() is...

Comments or Responses

More Interview Questions by Bhakti

Return type of RAND() is...
To terminate SQL Server immediately, used is…
SET OFFSETS specified settings are in effect at…
SET NOCOUNT specified settings are in effect at…
This is used to terminate a query when an overflow or divide-by-zero e ...
Can you control concatenation of string values with null values? How ?
What will you do if you need to create clustered index on more than on ...
How to deal with return value of stored procedure when you are using D ...

Latest Interview Questions

Webservices are created with the following two files
In how many ways you can deploy an Asp.Net Application?
Name the classes that are contained in System.Data NameSpace?
Name the classes are found in System.Data.Common NameSpace?
How is body onload() function is different from document.ready() funct ...
Which of the following method is correct to send an Email Message?
Difference between Eval() and Bind()?
What does dollar Sign ($) means in JQuery?
More ...