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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Difference between NVL and COALESCE

Author  Topic 

kawadeprasad
Starting Member

13 Posts

Posted - 2012-06-04 : 06:30:10
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

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-06-04 : 06:38:06
You better should ask that in an oracle forum because here we are on MS SQL Server only.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -