TRIGGER

CREATE trigger [dbo].[trgINSERT_Nilai] on [dbo].[TBNILAI]

for INSERT

as

   declare @v1 as char(3)

   declare @v2 as char(3)

   select @v1=KdMK,@v2=NIM from inserted

   update tbNilai

   set NAkhir=CONVERT(INT, 0.4*UTS + 0.6*UAS)

   where KdMK=@v1 and NIM=@v2return

CREATE trigger trgNilai on TBNilai for update

as

   declare @v1 as char(3)

   declare @v2 as char(3)

   select @v1=KdMK,@v2=NIM from inserted

   if update(UTS) or update(UAS) begin

      update TBNilai

      set NAkhir=0.4*UTS + 0.6*UAS

      where KdMK=@v1 and NIM=@v2

   end return

Trigger INSERT

pengujian 

TRIGGER UPDATE

 TRIGGER DELETE