Friday, March 6, 2009

Difference Between COALESCE And ISNULL

  1. COALESCE correctly promotes its arguments to the highest data type in the expression list, ISNULL does not
  2. ISNULL can only work with 2 values while COALESCE can take a lot more
  3. The alternate value takes the length of the first value with ISNULL, with COALESCE this doesn't happen
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)