3>
4> SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL') CONCAT_NULL_YIELDS_NULL
5> GO
CONCAT_NULL_YIELDS_NULL
------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------
1
(1 rows affected)