Trigger Kullanımı INSERT DELETE

DELETE
GO
ALTER TRIGGER [dbo].[DELETE-TEST] ON [dbo].[musteri1]
AFTER DELETE

AS BEGIN
declare @musterikodu int
declare @kontrolet int
SELECT @musterikodu = musterikodu FROM deleted
SET @kontrolet = (SELECT musterikodu FROM deneme2.dbo.musteri2 where musterikodu = @musterikodu )
IF(@kontrolet>0)

DELETE FROM deneme2.dbo.musteri2 WHERE musterikodu=@musterikodu;

END


INSERT
GO
ALTER TRIGGER [dbo].[INSERT_TEST] ON [dbo].[musteri1] 
FOR INSERT
AS
if getdate()>'2018-01-01' and getdate()<'2019-01-01'

begin
 
declare @ad varchar(50);
declare @soyad varchar(50);
declare @sehir varchar(50);
declare @musterikodu int
 
select @ad=ad from INSERTED;
select @soyad=soyad from INSERTED;
select @sehir=sehir from INSERTED;
select @musterikodu= musterikodu from INSERTED; 
INSERT INTO deneme2.dbo.musteri2(ad,soyad,sehir,musterikodu) values(@ad,@soyad,@sehir,@musterikodu);
 
end