Jeremy Holovacs
Member since Oct 8, 2010
- Profile: /members/7036-jeremy-holovacs.htm
- Comments: 1
Recent Blog Comments By Jeremy Holovacs
-
SQL COALESCE() Very Cool, But Slower Than ISNULL()
Posted on Oct 8, 2010 at 4:35 PM
COALESCE has 2 major advantages: 1) it is part of the ANSI 2000 standard which can make your sql more portable. This, however, is pointless to most people, as they usually work in exactly one environment. 2) you are not limited to two values. ISNULL, logically speaking, should perform better in mo... read more »