Freigeben über


BindDefault Method

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

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

Syntax

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.

HinweisHinweis

When you use the UserDefinedDatatype object, the bFutureOnly parameter is available in C/C++ applications.

Hinweise

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.