create table myTable(f1 int,f2 int)
 
 declare
  @f2 int = (select 1+1)

 insert into myTable(f1,f2)
 values(1,@f2)

 -- при использовании триггеров запрос измениться так
 insert into myTable(f1)
 values(1)

 -- instead of
 declare
  @f2 int = (select 1+1)

 insert into myTable(f1,f2)
 select  f1,@f2
 from inserted

 -- after
 declare
  @f2 int = (select 1+1)

 update t set
  f2 = @f2
 from myTable t
 join inserted i on i.f1 = t.f1