共用方式為

_TRIGGERLEVEL System Variable

  • 發行項

Contains a read-only numeric value indicating the current trigger procedure nesting level.

_TRIGGERLEVEL = nExpression

Parameters

  • nExpression
    Contains the current trigger procedure nesting level. _TRIGGERLEVEL contains 1 when the initial trigger procedure is executing. If a trigger procedure causes another trigger procedure to fire, _TRIGGERLEVEL is incremented by 1. _TRIGGERLEVEL contains 0 if a trigger procedure is not executing.

Remarks

Use CREATE TRIGGER to create a Delete, Insert, or Update trigger for a table. You can use APPEND PROCEDURES and MODIFY PROCEDURES to create stored procedures that are executed when a Delete, Insert, or Update trigger occurs.

_TRIGGERLEVEL contains a numeric value that is read-only. If you use STORE or = to assign a value to _TRIGGERLEVEL, the value is ignored.

See Also

APPEND PROCEDURES | CREATE TRIGGER | MODIFY PROCEDURE