请高手将mssql的存储过程转换成mysql的存储过程

2024-12-12 16:03:30
推荐回答(2个)
回答1:

CREATE PROCEDURE SP_UserPayment
(
IN @BinNumber VARCHAR(5),
IN @VANUMBER VARCHAR(16),
IN @TRACENO VARCHAR(6),
IN @TRNDATE VARCHAR(10),
IN @AMOUNT AS DECIMAL,
IN @currency VARCHAR(3),
IN @DELCHANNEL VARCHAR(3),
IN @terminalId varchar(8),
IN @Reference VARCHAR(20),
OUT @responseCode VARCHAR(2) ,
OUT @ResponseMessage VARCHAR(30)
)
AS
BEGIN
START TRANSACTION;
SET NOCOUNT on
--implemet sp
COMMIT
END;

回答2: