Where can I find the informations about the Trigger tables Inserted, Updated and Deleted? They are not available in sysobjects. Are they created and deleted after trigger is fired?
Printable View
Where can I find the informations about the Trigger tables Inserted, Updated and Deleted? They are not available in sysobjects. Are they created and deleted after trigger is fired?
There are only aliases for recordsets created in memory. They are only available inside trigger and are logically a part of table on which trigger is created (the same schema - but rows filled with deleted inserted etc).Quote:
Where can I find the informations about the Trigger tables Inserted, Updated and Deleted?
And what is "Updated" table :rolleyes: ? I don't know :D !
Best regards,
Krzemo.
Updated deosn't exist.
Updates use both the inserted and deleted names inserted is the entire row as it will look after the update completes. deleted is the snapshot of before.
Didn't I wrote it on my post?;)Quote:
Updated deosn't exist