Database.ConcatenateNullYieldsNull Database.ConcatenateNullYieldsNull Database.ConcatenateNullYieldsNull Property


Gets or sets a value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active.

 property bool ConcatenateNullYieldsNull { bool get(); void set(bool value); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Design)]
public bool ConcatenateNullYieldsNull { get; set; }
Public Property ConcatenateNullYieldsNull As Boolean
Property Value

A Boolean that specifies whether the ConcatenateNullYieldsNull database option is active. If True, the concatenated result is NULL. If False (default), the value is concatenated with a zero string.



This property specifies whether a value that is concatenated with a null value results in a null value or in a zero string.

Applies to