As per the BOL:

If all arguments are NULL, COALESCE returns NULL with Note: At least one of the null values must be a typed NULL.

Then why "SELECT COALESCE(NULL,NULL) AS [COALESCE]" is failed?