Skip to main content

COALESCE vs ISNULL

A good read. 

 Deciding between COALESCE and ISNULL in SQL Server (mssqltips.com)


Key Points : 

  • The COALESCE and ISNULL SQL Server statements handle data type precedence differently

COALESCE determines the type (and length) of the output based on data type precedence.   ISNULL takes the first parameter. 

  • The SQL Server COALESCE statement supports more than two arguments

  • COALESCE and ISNULL perform about the same (in most cases) in SQL Server
  • ISNULL is not consistent across Microsoft products/languages
  • COALESCE is ANSI standard




Comments

Post a Comment

Popular posts from this blog

NMAP

It's been about 15 years since I used NMAP, I forgot how useful the tool is. To find out what services are running on an IP address simply use something like nmap -n -v -p1-10000 x.x.x.x -n tells nmap not to do name resolution (saves about 13 seconds if the IP you're scanning isn't in DNS_ -v verbose -p1-10000 says scan ports 1 to 10,000 (otherwise nmap will only scan the first 1000 ports)
Post a Comment
Read more