Question

PB如何给存储过程中的变量赋值

ALTER proc [dbo].[MT_USE](@ems varchar(8000),@emd varchar(8000))
AS
select V.[item no_],sum(v.[item ledger entry quantity]) AS QTY_A,sum([Cost Amount (Actual)]+[Cost Amount (Expected)]) AS
COST_A,I.[item category code]
from [gulf semi(v080601)$value entry] V,[gulf semi(v080601)$item] i
where v.[item ledger entry type]= '5'
and I.no_=V.[ITEM no_]
AND v.[POSTING DATE] BETWEEN @EMS AND @EMD
group by v.[item no_],i.[item category code]

PB中
DECLARE P_MT_USE PROCEDURE FOR MT_USE;
execute P_MT_USE;
COMMIT;
messagebox('title','更新成功')
close P_MT_USE;
如何在此赋值@ems=ls_em_s,@emd=ls_em_e

Answer 1

DECLARE P_MT_USE PROCEDURE FOR MT_USE @ems=:ls_em_s,@emd=:ls_em_e;