The AnsiNullsStatus property returns True when the database object referenced depends on a table exhibiting SQL-92 NULL handling behavior.
| StoredProcedure Object | View Object |
| Trigger Object |
object.AnsiNullsStatus
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
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.
Boolean
Read-only
HRESULT GetAnsiNullsStatus(LPBOOL pRetVal);