Saturday, May 21, 2016

COALESCE and ISNULL


Source:

COALESCE and ISNULL

According to SQL Server Books Online, COALESCE "returns the first nonnull expression among its arguments," and ISNULL "replaces NULL with the specified replacement value." As a simple example, the following code demonstrates using the two functions:

No comments:

Post a Comment