What is the use of COALESCE function in SQL Server ?

Posted by Chikul on 12/21/2009 | Category: Sql Server Interview questions | Views: 4242

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Returns the first not null expression among its arguments.
COALESCE(X,Y,Z)

If X is Null then It'll check for Y,
If Y is Null It'll Check for Z.

Let X is NULL, Y='5' and Z='9'
Here Output is : Y

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What exactly a Constructor is doing ?

Next > : Can you store multiple data types in System.Array?

Comments or Responses

More Interview Questions by Chikul

Can you store multiple data types in System.Array?
What is the Magic Tables in Sqlserver2000?
What is a Join in SQL Server?
How to get number of Maximum connection can be establish to SQL
What is the difference between UNION ALL Statement and UNION
What are the different types of Locks
What is COMMIT and ROLLBACK statement in SQL
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE ?

Latest Interview Questions

What is next number in this series? 1, 3, 4, 8, 15, 27,_
Find out next number in this series? 0, 2, 3, 5, 8, 10, 15, 17, 24, 2 ...
What is next number in the series 1,2,3,5,7,11,_
What will be next number in this series. 2, 5, 9, 19, 37,__
What is difference between var and Dynamic ?
What is PLINQ
What is dynamic keyword ?
There is one word in the English language that is always pronounced in ...
More ...