5 replies
by roc180
Use the system table Inserted.
SELECT FieldA FROM Inserted
If you need to compare the old value to the new check the system table Deleted.
Good Luck
Neal Martinelli
by chrisk
by glen_mcleod
When a trigger is fired, 2 virtual table become available called 'inserted' and 'deleted'. On a delete, the 'inserted' table will be empty but the 'deleted' table will have data, and the opposite for an insert.
On an update, the old data will be in 'deleted', and the new data will be in 'inserted', so just reference these tables as you need.
There're *only* available to triggers.
Glen
by chrisk
by chrisk
This discussion is closed to new replies.
Trending Networks posts
Sort by Trending