次の方法で共有

BindDefault Method

  • [アーティクル]

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

The BindDefault method implements Microsoft SQL Server default binding and unbinding for columns and user-defined data types.

構文

object
.BindDefault(
DefaultOwner
,
DefaultName
,
Bind [,bFutureOnly])

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • DefaultOwner
    String identifying the database user owning the bound default.
  • DefaultName
    String identifying the bound default by name.
  • Bind
    TRUE or FALSE as described in Settings.
  • bFutureOnly
    TRUE or FALSE. This is an optional parameter that applies only to the UserDefinedDatatype object.

Prototype (C/C++)

HRESULT BindDefault(SQLDMO_LPCSTR DefaultOwner,
SQLDMO_LPCSTR DefaultName, BOOL Bind, BOOL bFutureOnly);

Settings

When Bind is TRUE, the default named is bound to the column or user-defined data type referenced.

When Bind is FALSE, any default is unbound from the referenced column or user-defined data type. The DefaultOwner and DefaultName properties are ignored.

ms133569.note(ja-jp,SQL.90).gifメモ :
When you use the UserDefinedDatatype object, the bFutureOnly parameter is available in C/C++ applications.

解説

The BindDefault method of the Column or UserDefinedDatatype object, and the BindToColumn and BindToDatatype methods of the Default object, associate a SQL Server default with a user-defined data type or column.

The BindDefault method does not cause a check of existing values when a new default is indicated for a column or user-defined data type.

Applies to:

Column Object

UserDefinedDatatype Object