SQL SERVER TRIGGER TRANSLATION

From: Fred Burlaud <fburlaud_at_com6.fr>
Date: Wed, 26 Jun 2002 19:30:47 +0200
Message-ID: <3D19FA47.9010405@com6.fr>

Hello,

I fail in translating this sql server trigger with the oracle syntax especially on the syntax "from inserted"

thank you ;o)
Fred

CREATE TRIGGER TR_UPDATE_ResAppelHisto

    ON ResAppelHisto
    FOR UPDATE
    NOT FOR REPLICATION     AS
    IF UPDATE(ResAppel)

        BEGIN
            DECLARE    @cpResAppel int
            SELECT    @cpResAppel = ResAppel FROM inserted
        UPDATE    Trig_ResAppelStat SET Cpt=Cpt+1 WHERE ResAppel = 

@cpResAppel

    END Received on Wed Jun 26 2002 - 12:30:47 CDT