Text Property

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The Text property exposes the Transact-SQL or other script that defines the referenced Microsoft SQL Server database object.

Syntaxe

object
.Text [=value]

Parts

• object
  An expression that evaluates to an object in the Applies To list

• value
  A string that satisfies the constraints on definition text for the referenced object

Data Type

String

Modifiable

Read/write when using a SQL Distributed Management Objects (SQL-DMO) object to create a SQL Server database object. Read-only when a SQL-DMO object references an existing database object.

Prototype (C/C++)

HRESULT GetText(SQLDMO_LPBSTR pRetVal);
HRESULT SetText(SQLDMO_LPCSTR NewValue);

Remarque :
SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

Notes

Constraints apply to strings used to set the Text property. For example, the Text property of a Check object contains an expression that evaluates to TRUE or FALSE. For a Trigger object, the Text property contains a Transact-SQL statement that creates a trigger when run. For more information, see documentation for the applicable SQL-DMO object.

Applies To:

Voir aussi

Référence

Alter Method

Aide et Informations

Assistance sur SQL Server 2005