CREATE TRIGGER dbo.ViewUpdatedRecords
ON (table name)
AFTER UPDATE
AS
BEGIN
SELECT *
INTO UpdatedRecords
FROM INSERTED
END
GO
It only works one time, as SELECT INTO creates a table and will complain if a table by that name already exists. But it only took a minute to write, and helped me solve my issue very quickly.
No comments:
Post a Comment