|
-
May 4th, 2005, 09:10 AM
#1
Trigger Tables
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?
Madhivanan
Failing to plan is Planning to fail
-
May 5th, 2005, 08:35 AM
#2
Re: Trigger Tables
Where can I find the informations about the Trigger tables Inserted, Updated and Deleted?
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).
And what is "Updated" table  ? I don't know  !
Best regards,
Krzemo.
-
May 5th, 2005, 12:20 PM
#3
Re: Trigger Tables
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.
-
May 6th, 2005, 02:55 AM
#4
Re: Trigger Tables
Didn't I wrote it on my post?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote