COALESCE in SQL Server

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

Syntax: -COALESCE ( expression [ ,...n ] ) 
Example: -SELECT COALESCE(NULL, NULL, NULL, GETDATE()) 




No comments:

Post a Comment