USE [Fatura] GO /****** Object: Trigger [dbo].[trHurdaHesapKayitDegisimTarihi] Script Date: 03/25/2010 14:10:38 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [dbo].[trHurdaHesapKayitDegisimTarihi] ON [dbo].[HurdaHesap] FOR UPDATE AS UPDATE HurdaHesap SET HurdaHesap.KayitDegisimTarihi = getdate() FROM HurdaHesap INNER JOIN Inserted ON HurdaHesap.MusteriID = Inserted.MusteriID