SQL-DMO

AnsiNullsStatus Property

The AnsiNullsStatus property returns TRUE when the database object referenced depends on a table exhibiting SQL-92 NULL handling behavior.

Applies To
StoredProcedure Object Trigger2 Object
StoredProcedure2 Object UserDefinedFunction Object
Table2 Object View Object
Trigger Object View2 Object

Syntax

object.AnsiNullsStatus

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read/write when creating a StoredProcedure2, Trigger2, UserDefinedFunction, or View2 object. Read-only when using a StoredProcedure, Trigger, or View object, or after a StoredProcedure2, Trigger2, UserDefinedFunction, or View2 object is created.

Prototype (C/C++)

HRESULT GetAnsiNullsStatus(LPBOOL pRetVal);

Remarks

By default, Microsoft® SQL Server™ creates columns that do not accept NULL when the user does not explicitly declare the ability to accept NULL. Further, SQL Server returns TRUE when evaluating the expression NULL = NULL. These default behaviors are nonstandard.

Database and client connection options override default SQL Server behavior. When the default is overridden, tables created exhibit SQL-92 standard NULL handling and objects that depend upon those tables function as specified by SQL-92.

Note  If an application calls AnsiNullsStatuson an instance of SQL Server version 7.0 with the Table2 object, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000" are returned.