CREATE TRIGGER [dbo].[Kunden_tru] ON [dbo].[Kunden] WITH EXECUTE AS CALLER FOR UPDATE AS DECLARE @a VARCHAR(255) DECLARE @b VARCHAR(14) DECLARE @c VARCHAR(14) DECLARE @d Datetime DECLARE @e Datetime declare @aa varchar (90) declare @spalte varchar(90) IF UPDATE(Name) set @spalte = 'Name' SET @a = (SELECT deleted.Name FROM deleted) SET @b = (SELECT inserted.Name FROM inserted) IF UPDATE(Vorname) set @spalte = 'Vorname' SET @a = (SELECT deleted.Vorname FROM deleted) SET @b = (SELECT inserted.Vorname FROM inserted) SET @c = @a + ' / ' + @b SET @d = GETDATE() set @e = (select Aufgenommen_am from deleted) -- set @aa = COLUMNS_UPDATED() insert into TBL_Log_Bewegung values(@c,'Kunden',@spalte,@d,@e) GO
58.4k Fragen
249k Antworten
7k Nutzer