Friday, January 3, 2014

how to replace null values in sql with customize value

ISNULL:-Replaces NULL value with the specified replacement value.

COALESCE:-Returns the first nonnull expression among its arguments.

For e.g.



CASE Statement:-Evaluates a list of conditions and returns one of multiple possible result expressions.

For e.g.



No comments:

Post a Comment