set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER TRIGGER [dbo].[rwina]
ON [dbo].[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

select * from pilote where pil#=@Npil--UPDATE A DEJA PRIS PLACE

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

select * from pilote where pil#=@Npil--AFFICHAGE APRES NOTRE UPDATE
END

UPDATE pilote
set nom='pluplu',sexe='F',datenaissance='10/10/2123',ville='Florida'
where pil#=1