AnsiNullsStatus Property

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。 新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。

The AnsiNullsStatus property returns TRUE when the database object referenced depends on a table exhibiting ISO 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 View2object 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 ISO standard NULL handling and objects that depend upon those tables function as specified by ISO.

注意
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 or later" are returned.

Applies To:

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