Type Property (Trigger)
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 Type property exposes configured attributes of the referenced Microsoft SQL Server component.
Syntax
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. |
Hinweise
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.