CREATE TRIGGER [dbo].[EventUpdate]
ON [dbo].[Events]
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO [dbo].Logs([date],[user],[changes],[eventId])
SELECT getdate(), 'john', I.columnname + '-->' + D.columnname, I.id
FROM Inserted I
INNER JOIN Deleted D ON I.id = D.id
END
GO