create trigger mytri
on tablename
for update
as
update mytable set name='value' from inserted where mytable.id= inserted.id
on tablename
for update
as
update mytable set name='value' from inserted where mytable.id= inserted.id
on table
for update
as
update mytable
set name='value'
where id=(select id from deleted)
create trigger mytri
on table
for update
as
update mytable set name='value' where id=(select top 1 id from inserted)