AnsiNullsStatus Property
Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.
The AnsiNullsStatus property returns TRUE when the database object referenced depends on a table exhibiting SQL-92 NULL handling behavior.
구문
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);
주의
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.
[!참고] 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.