• 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