SQL Server - Inserted Table

samgray

New Member
I am checking the output of the inserted / deleted table using the following trigger, how can I pass on the intercepted UPDATE command to the server after verifying columns?\[code\]CREATE TRIGGER Test1_LastUpdate ON Test1INSTEAD OF UPDATE AS SELECT * FROM Inserted SELECT * FROM DeletedGO\[/code\]EDIT: I am looking for a solution that will not need to be changed after schema updates.\[code\]CREATE TRIGGER Test1_LastUpdate2 ON Test1INSTEAD OF UPDATEAS --COMMIT UPDATE THAT WAS INTERCEPTEDEND\[/code\]
 
Top