AnsiNullsStatus Property
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The AnsiNullsStatus property returns TRUE when the database object referenced depends on a table exhibiting SQL-92 NULL handling behavior.
Sintaxis
object
.AnsiNullsStatus
Parts
- object
An expression that evaluates to an object in the Applies To list
Data Type
Boolean
Modifiable
Read/write when a StoredProcedure2, Trigger2, UserDefinedFunction, or View2 object is created. Read-only when a StoredProcedure, Trigger, or View object is used, or after a StoredProcedure2, Trigger2, UserDefinedFunction, or View2 object is created.
Prototype (C/C++)
HRESULT GetAnsiNullsStatus(LPBOOL pRetVal);
Notas
By default, Microsoft SQL Server creates columns that do not accept NULL unless the user explicitly declares 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. If 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.
[!NOTA] If an application calls AnsiNullsStatus on 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 or later" are returned.