Type Property (Trigger)

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The Type property exposes configured attributes of the referenced Microsoft SQL Server component.

Sintaxis

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.

Notas

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.

Applies To:

Trigger Object