DML Trigger Snippet 5

DML_Trigger_Snippet_5.sql

CREATE TABLE dbo.CustomerNameAudit
( 
  CustomerName Varchar(10) NOT NULL, 
  ChangeDate DATETIME DEFAULT(GETDATE()) NOT NULL
)
GO
CREATE TRIGGER dbo.Customers_AfterUpdateInsertAudit
    ON dbo.Customers
 AFTER UPDATE, INSERT
AS
BEGIN
  INSERT INTO CustomerNameAudit( CustomerName)
  SELECT i.CustomerName
    FROM inserted i
END
GO
INSERT INTO dbo.Customers(CustomerName) 
VALUES('Maks Z.o.o')
INSERT INTO dbo.Customers(CustomerName) 
VALUES('Asia S.A.')
GO
UPDATE Customers
SET CustomerName = 'Asia & Co.'
WHERE CustomerName = 'Asia S.A.'
GO
SELECT CustomerName, ChangeDate
  FROM CustomerNameAudit
 ORDER BY CustomerName
GO
DROP TRIGGER dbo.Customers_AfterUpdateInsertAudit;
GO