DML Trigger Snippet 2

DML_Trigger_Snippet2.sql

CREATE VIEW dbo.vCustomers
AS
  SELECT CustomerName FROM dbo.Customers
GO
CREATE TRIGGER dbo.vCustomers_AfterDelete
    ON dbo.vCustomers
INSTEAD OF DELETE
AS
BEGIN
DELETE c
  FROM dbo.Customers c
 INNER JOIN deleted d
    ON c.CustomerName = d.CustomerName
END
GO
INSERT INTO dbo.Customers(CustomerName) 
VALUES('Jef')
GO
DELETE vCustomers WHERE CustomerName = 'Jef'
GO
DROP TRIGGER dbo.vCustomers_AfterDelete
GO  

--Results:
--(1 row(s) affected)
--(1 row(s) affected)
--(1 row(s) affected)