MssqlTriggerKind enum

What kind of trigger the target table carries.

Not a detail: it decides which readback SQL Server will even accept, and whether @@ROWCOUNT is describing the caller's statement or the trigger's last one.

Inheritance

• Object
• Enum
• MssqlTriggerKind

Available extensions

• EnumName

Values

none → const MssqlTriggerKind

No enabled trigger. OUTPUT without INTO is allowed, and @@ROWCOUNT read immediately after the statement is that statement's own count.

after → const MssqlTriggerKind

An AFTER trigger. SQL Server rejects a bare OUTPUT (error 334), so the written keys go into a table variable and the rows are read back from it. @@ROWCOUNT may be the trigger body's, so it is not used.

insteadOf → const MssqlTriggerKind

An INSTEAD OF trigger. The statement the caller wrote never runs, so nothing the server reports describes it. Readback must be declared.

Properties

hashCode → int

The hash code for this object.

no setter, inherited

index → int

A numeric identifier for the enumerated value.

no setter, inherited

name → String

Available on Enum, provided by the EnumName extension

The name of the enum value.

no setter

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited

Constants

values → const List<MssqlTriggerKind>

A constant List of the values in this enum, in order of their declaration.