avoid recursive trigger execution

علی ذوالفقار
1403/06/17 14:44:52 (50)

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