When ON is specified, the result of a concatenation operation is NULL when either operand is NULL.

• 当指定为ON时,如果串联操作的两个操作数中任意一个为NULL,则结果也为NULL。