Type Property (Trigger)
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 Type property exposes configured attributes of the referenced Microsoft SQL Server component.
Syntaxe
object
.Type
Parts
- object
An expression that evaluates to an object in the Applies To list
Data Type
Long, enumerated
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetType(SQLDMO_TRIGGER_TYPE* pRetVal)
Returns
For a Trigger object, interpret the Type property using these values.
Constant |
Value |
Description |
|---|---|---|
SQLDMOTrig_All |
7 |
Fired by any data modification statement. |
SQLDMOTrig_Delete |
4 |
Fired by a DELETE statement. |
SQLDMOTrig_Insert |
1 |
Fired by an INSERT statement. |
SQLDMOTrig_Unknown |
0 |
The value is not valid. |
SQLDMOTrig_Update |
2 |
Fired by an UPDATE statement. |
Notes
A SQL Server trigger can fire when a Transact-SQL INSERT, UPDATE, or DELETE statement modifies data in the table on which the trigger is defined.
The Transact-SQL script defining the trigger determines the Transact-SQL statements that cause firing. For more information, see Text Property.