• Hi!

    You are absolutely right!

    but here is the correct version that works with multiple rows

     

     UPDATE [Table_Name]

     SET field1=i.field1,

    field1=i.field1,

           'Put Here all the fields of the table

    conn_string=i.conn_string,

      last_modified=getdate()  

     FROM inserted i

     INNER JOIN f6bo_Projectos  ON i.id_projecto = f6bo_Projectos.id_projecto


    Tiago Andrade e Silva