SQL Server INSERT UPDATE and DELETE Triggers Log Table Example

It is not possible for us to give exact solutions, but I will make simple for you using my example

Database I have made use of the following table Customers with the schema as follows.

I have already inserted few records in the table.

And finally the CustomerLogs table which will log the Trigger actions.

 Download SQL file

INSERT Trigger

CREATE TRIGGER [dbo].[Customer_INSERT]
ON [dbo].[Customers]
AFTER INSERT
AS
BEGIN
	DECLARE @CustomerId INT

	SELECT @CustomerId = INSERTED.CustomerId        
    FROM INSERTED

	INSERT INTO CustomerLogs
	VALUES(@CustomerId, 'INSERT')
END
GO

UPDATE Trigger

CREATE TRIGGER [dbo].[Customer_UPDATE]
ON [dbo].[Customers]
AFTER UPDATE
AS
BEGIN
	DECLARE @CustomerId INT
	DECLARE @Action VARCHAR(50)

	SELECT @CustomerId = INSERTED.CustomerId        
    FROM INSERTED

	IF UPDATE(Name)
	BEGIN
		SET @Action = 'UPDATED Name'
	END

	IF UPDATE(Country)
	BEGIN
		SET @Action = 'UPDATED Country'
	END

	INSERT INTO CustomerLogs
	VALUES(@CustomerId, @Action)
END
GO

DELETE Trigger

CREATE TRIGGER [dbo].[Customer_DELETE]
ON [dbo].[Customers]
AFTER DELETE
AS
BEGIN
	DECLARE @CustomerId INT

	SELECT @CustomerId = DELETED.CustomerId        
    FROM DELETED

	INSERT INTO CustomerLogs
	VALUES(@CustomerId, 'DELETED')
END
GO

The following screenshot displays the Logs by the above three Triggers.