IDatabaseOptions.AnsiNullsEnabled IDatabaseOptions.AnsiNullsEnabled IDatabaseOptions.AnsiNullsEnabled Property

Definition

Gets or sets a Boolean property value that specifies whether the ANSI_NULLS_ENABLED database option is active.

public:
 property bool AnsiNullsEnabled { bool get(); void set(bool value); };
[Microsoft.SqlServer.Management.Sdk.Sfc.DisplayDescriptionKey("Database_AnsiNullsEnabledDesc")]
[Microsoft.SqlServer.Management.Sdk.Sfc.DisplayNameKey("Database_AnsiNullsEnabledName")]
public bool AnsiNullsEnabled { get; set; }
Public Property AnsiNullsEnabled As Boolean
Property Value

A Boolean value that specifies whether the ANSI_NULLS_ENABLED database option is active.

If True, comparisons to null values equate to false.

If False (default), comparisons to null values equate to true.

Examples

How to Get and Set a Property in Visual Basic .NET

Remarks

This property specifies whether any comparison to a null value equates to a NULL value. For example, A SELECT statement using WHERE column_name <> NULL returns zero rows even if there are non-null values in column_name

This option can also be changed by using the Transact-SQL ALTER DATABASE statement.

Applies to