|
I saw that our company's software background uses such stored procedures.The only input parameters provided are, but the stored procedure provides return according to the execution situation.I don't know if this way of writing replaces the OUTPUT parameter.
How to call the stored procedure in Delphi, get the return value of return, and do different processing.
create procedure SBP_jx_kpdd
@gzid char (20), @ djlxbs char (3)
as
/ ************************************************* ************** /
--Procedure topic: Invoice Billing Check to see if there is an order errorID = 2100
/ ************************************************* ************** /
declare @errcode integer
set @ errcode = 2100
declare @return integer / * initialization of return results * /
set @ return = 0
...
...
return = @ return |
|