存儲過程:
CREATE procedure update_yangjie
@test_code char(50)
as
begin
update 商品基礎資訊表 set 商品名稱='happy' where 商品編号= @test_code
end
GO
PB 調用過程:
declare pr_get procedure for update_yangjie
@test_code="SP100004"
using sqlca;
execute pr_get;
commit;
MESSAGEBOX("提示","存儲過程調用成功!")
close pr_get;