The tables accessible via a trigger are "inserted" and "deleted". In an
update scenario, the inserted and deleted tables maintain the "after" and
"before" states, respectively. You can use both the inserted and deleted
table as you could any other temporary table.
"Harris M." <pinta55hotmail.com> wrote in message
news:097f01c33f39$c37b9d90$a001280aphx.gbl...> Hello All,
> Is this a valid trigger? Is "Updated" an actual table and
> can I use it to update tables in other databases? Thanks
> in advance for your kind help.
> create trigger trans on contact2
> for update as
> IF EXISTS ( SELECT * FROM Updated WHERE ugpstatus like '%
> UPDATE testprospect.contact2 SET ul_matdt = getdate(),
> ul_amoedt = getdate()
> WHERE testprospect.contact2.company = 'test'