What you need to know about SQL Server Triggers for data analysts

Find out how to find triggers in SQL server & what they might mean to you as a data analyst. We're not data engineers, after all!

ALTER TABLE FoodAccessResearch
ADD CreatedAt DATETIME;
GO

CREATE TRIGGER trg_SetCreatedAt
ON FoodAccessResearch
AFTER INSERT
AS
BEGIN
UPDATE FoodAccessResearch
SET CreatedAt = GETDATE()
FROM FoodAccessResearch FAR
INNER JOIN inserted i ON FAR.CensusTract = i.CensusTract
END;

SELECT name, create_date, modify_date FROM sys.triggers;

Видео What you need to know about SQL Server Triggers for data analysts канала Coffee Break Data