Row triggers equivalent in sql server 2000

[=?iso-8859-1?B?RmFkpQ==?=]

Hello Guys!
i have been working with oracle with quite a time. No i migrated to sql
server 2000 and i want to create a trigger on a table.
the trigger function has to update the Modification field to getdate()
whenever a row is being updated.
i tried lots of things

if anyone can help i would appreciate a lot!

Regards

[AlterEgo]

Fad¥,

This should work for you:

create trigger MyTrigger on MyTable for insert, update
as
begin
update MyTable
set Modification = getdate()
from MyTable m
inner join inserted i on m.MyTableID = i.MyTableID
end

-- Bill

"Fad¥" <fa****@gmail.comwrote in message
news:11*********************@m58g2000cwm.googlegro ups.com...

Hello Guys!
i have been working with oracle with quite a time. No i migrated to sql
server 2000 and i want to create a trigger on a table.
the trigger function has to update the Modification field to getdate()
whenever a row is being updated.
i tried lots of things

if anyone can help i would appreciate a lot!

Regards

[=?iso-8859-1?B?RmFkpQ==?=]

Thanks AlterEgo for the help!
now i get the functionality of inserted and deleted tables