What is the difference between coalesce() & isnull()?
- 1 Answers
- 1249 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is standby servers? Explain types of standby servers.
Equi join and non equi join is possible with sql server?
what is spatial nonclustered index
Disadvantages of the indexes?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Why should you use or avoid select * statements?
What is a scheduled job or what is a scheduled task?
What is sql server query analyzer?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is temporary table in sql server? Why we use temp table?
what is the difference between openrowset and openquery?
How efficient you are in oracle and SQL server?
What is subquery? Explain the properties of a subquery?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
List out the different types of locks available in sql server?
