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.