SQL Trigger

sql_triggers.sql

CREATE TRIGGER User_log_INSERT on dbo.Users
AFTER INSERT AS
BEGIN
INSERT INTO dbo.Users_log
( uuid, firstname, lastname, age, social, gender, action, changeuser, modifiedOn)
  SELECT  i.uuid, i.firstname, i.lastname, i.age, i.social, i.gender, 'INSERTED',  SUSER_NAME(), GETDATE()  FROM inserted i
END

CREATE TRIGGER User_log_UPDATE on dbo.Users
AFTER UPDATE AS
BEGIN
INSERT INTO dbo.Users_log
( uuid, firstname, lastname, age, social, gender, action, changeuser, modifiedOn)
  SELECT  i.uuid, i.firstname, i.lastname, i.age, i.social, i.gender, 'UPDATED',  SUSER_NAME(), GETDATE()  FROM inserted i
END

CREATE TRIGGER User_log_DELETE on dbo.Users
AFTER DELETE AS
BEGIN
INSERT INTO dbo.Users_log
( uuid, firstname, lastname, age, social, gender, action, changeuser, modifiedOn)
  SELECT  i.uuid, i.firstname, i.lastname, i.age, i.social, i.gender, 'UPDATED',  SUSER_NAME(), GETDATE()  FROM deleted i
END