Keeping a history of row changes
The Fresh Fruit Delivery company needs to track changes made to the Customers table.
You are asked to create a new trigger that covers any statements modifying rows in the table.
Este ejercicio forma parte del curso
Building and Optimizing Triggers in SQL Server
Instrucciones del ejercicio
- Create a new trigger called
CopyCustomersToHistory. - Attach the trigger to the
Customerstable. - Fire the trigger when rows are added or modified.
- Extract the information from the
insertedspecial table.
Ejercicio interactivo práctico
Prueba este ejercicio completando el código de muestra.
-- Create a trigger to keep row history
CREATE TRIGGER ___
ON ___
-- Fire the trigger for new and updated rows
AFTER ___, UPDATE
AS
INSERT INTO CustomersHistory (CustomerID, Customer, ContractID, ContractDate, Address, PhoneNo, Email, ChangeDate)
SELECT CustomerID, Customer, ContractID, ContractDate, Address, PhoneNo, Email, GETDATE()
-- Get info from the special table that keeps new rows
FROM ___;