avoid recursive trigger execution

👤 علی ذوالفقار 📅 1403/06/17 14:44:52 👁️ 82 views

This Code will run only one time in trigger

CREATE TRIGGER TRG_SAMPLE ON TBL_SAMPLE
AFTER INSERT, UPDATE
AS
BEGIN
    IF TRIGGER_NESTLEVEL(@@PROCID) = 1
    BEGIN
        INSERT TBL_SAMPLE(FNAME) VALUES ("")
    END 
END

← Back to Posts