CREATE TRIGGER rwina
ON pilote
AFTER UPDATE
AS
BEGIN
Declare @sexe varchar(50),@Npil int,@date datetime

select @sexe = sexe from deleted
select @date = datenaissance from deleted

select @Npil = pil# from deleted

    IF  (update(sexe) or update(datenaissance))
    BEGIN
        COMMIT TRANSACTION

        BEGIN TRANSACTION changement

            update pilote
            set sexe = @sexe,datenaissance =@date
            where pil# = @Npil


         COMMIT TRANSACTION changement
        END
END
--code pour tester
UPDATE pilote
set sexe='F',datenaissance='01/01/2001',nom='tuvoix'
WHERE pil#=1