Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kawadeprasad
Starting Member
13 Posts |
 Posted - 2012-06-04 : 06:40:46
|
| Hi,I would like to know the difference bet NVL and COALESCE.performance wise which is better?what are the merits and demerits of each of those?Where it's recommended to use?Thanks in advance!!!-Prasad |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-06-04 : 09:25:12
|
| NVL is an Oracle feature, IIRC. SQLTeam is a Microsoft SQL Server website. You can find more information on NVL here: http://www.techonthenet.com/oracle/functions/nvl.phpThe most basic difference is that COALESCE can evaluate multiple replacement values, while NVL can only accept one. If there is a performance difference it's probably negligible. |
 |
|
|
|
|
|
difference bet NVL and COALESCE