1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the difference between coalesce() & isnull()?

Question Posted / prashanth


What is the difference between coalesce() & isnull()?..

Answer / Gyandev Kumar

{"answers": ["Both Coalesce() and ISNULL() are used to handle NULL values, but they behave slightly differently. Coalesce() returns the first non-null value in a list of arguments while ISNULL() replaces all null values with a specified value."]}

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

how can i store resumes in database?

3 Answers   HCL,

Explain throw statement in sql server 2008?

1 Answers  

What is oltp (online transaction processing)?

1 Answers  

What are commonly used mssql functions in php?

1 Answers  

Why would you call update statistics?

1 Answers  

Explain ms sql server reporting services vs crystal reports?

1 Answers  

What is a coalesce function?

0 Answers  

Define compound operators?

1 Answers  

What are the types of dml?

1 Answers  

What do you understand by hotfixes and patches in sql server?

1 Answers  

How to set database to be single_user in ms sql server?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories