Partilhar via

  • Artigo

AfterTrigger Property

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

The AfterTrigger property indicates whether a trigger is an AFTER trigger.

Sintaxe

object.AfterTrigger

Parts

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

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetAfterTrigger(LPBOOL pRetVal);

Comentários

AFTER triggers fire after the triggering action (INSERT, UPDATE, or DELETE) and after any constraints have been processed. AFTER triggers can only be created on tables.

All triggers created using Microsoft SQL Server version 7.0 or earlier are AFTER triggers.

ObservaçãoObservação

If an application calls AfterTriggeron an instance of SQL Server7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.

Applies To:

Trigger2 Object

Consulte também

Referência

InsteadOfTrigger Property