CREATE TRIGGER FATGOLF_DELETE ON FatGolf FOR DELETE AS Declare @FatNo Int, @AlSat VarChar(1), @MusNo int Select @FatNo = FatNo, @AlSat=AlSat, @MusNo=MusNo From Deleted if @AlSat = 'A' update RezGolf Set AlFatNo = 0 Where AlFatNo = @FatNo and MusNo = @MusNo else update RezGolf Set SatFatNo = 0 Where SatFatNo = @FatNo and MusNo = @MusNo
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
CREATE TRIGGER FATGOLF_INSERT ON FatGolf FOR Insert AS Declare @FatNo Int, @AlSat VarChar(1), @MusNo int, @PaketAlis VarChar(6), @PaketSatis VarChar(6), @PktAlSira smallint, @PktSatSira smallint, @Sira smallint Select @FatNo = FatNo, @AlSat=AlSat, @MusNo=MusNo, @PaketAlis = PaketAlis, @PaketSatis = PaketSatis, @PktAlSira = PktAlSira, @PktSatSira = PktSatSira, @Sira = Sira From Inserted if (@AlSat = 'A') and (@PaketAlis <> '' and @PaketAlis is not null) update RezGolf Set AlFatNo = @FatNo Where MusNo = @MusNo and PaketAlis = @PaketAlis and PktSiraAlis = @PktAlSira if (@AlSat = 'S') and (@PaketSatis <> '' and @PaketSatis is not null) update RezGolf Set SatFatNo = @FatNo Where MusNo = @MusNo and PaketSatis = @PaketSatis and PktSira = @PktSatSira if (@AlSat = 'A') and (@PaketAlis = '' or @PaketAlis is null ) update RezGolf Set AlFatNo = @FatNo Where MusNo = @MusNo and Sira = @Sira if (@AlSat = 'S') and (@PaketAlis = '' or @PaketAlis is null ) update RezGolf Set SatFatNo = @FatNo Where MusNo = @MusNo and Sira = @Sira
@DonTrf VarChar(1), @DonTrfTar DateTime, @DonTrfTuru VarChar(4), @DonTrfNo Int
if Update(Otel) or Update(Saha) or Update(Conf) or Update(Tarih) or Update(GidTrf) or Update(GidTrfTar) or Update(GidTrfTuru) or Update(DonTrf) or Update(DonTrfTar) or Update(DonTrfTuru)
begin
Select @GelTrfNo=GelTrfNo, @DonTrfNo=DonTrfNo From Deleted