Difference between COALESCE() & ISNULL() ?
ISNULL accepts only 2
parameters. The first parameter is checked for NULL value, if it is NULL then
the second parameter is returned, otherwise it returns first parameter.
COALESCE accepts two or
more parameters. One can apply 2 or as many parameters, but it returns only the
first non NULL parameter.
No comments:
Post a Comment