Database.ConcatenateNullYieldsNull Property
Gets or sets a property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Deklaracja
<SfcPropertyAttribute> _
Public Property ConcatenateNullYieldsNull As Boolean
[SfcPropertyAttribute]
public bool ConcatenateNullYieldsNull { get; set; }
[SfcPropertyAttribute]
public:
virtual property bool ConcatenateNullYieldsNull {
bool get () sealed;
void set (bool value) sealed;
}
/** @property */
public final boolean get_ConcatenateNullYieldsNull ()
/** @property */
public final void set_ConcatenateNullYieldsNull (boolean value)
public final function get ConcatenateNullYieldsNull () : boolean
public final function set ConcatenateNullYieldsNull (value : 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.
Remarks
This property specifies whether a value that is concatenated with a null value results in a null value or in a zero string.
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.