Tuesday, 30 July 2013

What is use of ISNULL and Coalesce functions?

Is Null function check for null, if the value is null set user assigned value. Limitation is ISNULL allow only two columns. Coalesce returns the first non-null column from more than one columns.

No comments:

Post a Comment