Вызов скалярной функции

create procedure mul (a int,  b int)
returns (result int)
as
begin
  result=a*b;
end

update
  tbl
set
  f3=mul(f1,f2)

/* select * from mul(2,3); */
/* select mul(2,3) from rdb$database; */
execute procedure mul(2,3);

execute block as
declare a integer;
begin
   execute procedure mul(2,3) returning_values :a;
   update t set f=:a;
end

Posted via ActualForum NNTP Server 1.5

update
tbl
set
f3=mul(f1,f2)
where
id in (select Id from sp(new.Id));

create or alter procedure mul (a int,  b int)
returns (result int)
as
begin
  result=a*b;
  suspend; -- это важно
end

merge into mytable t using (
select
  t.id,
  m.result
from
  mytable t
  left join mul(t.f1,t.f2) m on 1=1
) s
on (t.id = s.id) when matched then update set t.f3 = s.result

update tbl
  set F1= :a * :b;

  suspend; -- это важно

/* oracle */
r := mul(2, 3);

/* mssql */
set @r=dbo.mul(2,3)

/* oracle */
update tbl set f3 = mul(f1, f2);
select mul(f1, f2) from tbl;

/* mssql */
update tbl set f3=dbo.mul(f1, f2)
select dbo.mul(f1, f2) from tbl