BindDefault Method
Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The BindDefault method implements Microsoft SQL Server default binding and unbinding for columns and user-defined data types.
Sintassi
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.
[!NOTA] When you use the UserDefinedDatatype object, the bFutureOnly parameter is available in C/C++ applications.
Osservazioni
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.