opss ... posted in the middle of editing
here is the general version:
UPDATE [Table_Name]
SET field1=i.field1,
field1=i.field1,
'Put Here all the fields of the table
last_modified=getdate()
FROM inserted i
INNER JOIN [Table_Name] ON i.id= [Table_Name].id
Thanks for your remark.
Tiago
Tiago Andrade e Silva