请高手将mssql的存储过程转换成mysql的存储过程
补充:CREATE PROCEDURE [dbo].[SP_UserPayment]
@BinNumber VARCHAR(5)
@VANUMBER VARCHAR(16)
@TRACENO VARCHAR(6)
@TRNDATE VARCHAR(10)
@AMOUNT AS DECIMAL
@currency VARCHAR(3)
@DELCHANNEL VARCHAR(3)
@terminalId varchar(8)
@Reference VARCHAR(20)
@responseCode VARCHAR(2) OUTPUT,
@ResponseMessage VARCHAR(30) OUTPUT
AS
BEGIN
BEGIN Transaction
SET NOCOUNT on
--implemet sp
COMMIT TRANSACTION
END
追问:就是把上面的存储过程转换成MYSQL版本的。好像MSSQL跟MYSQL版本的存储过程不同。
答案: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;
上一个:MSSQL 转到 MYSQL ,划算吗?
下一个:mssql 2个表结果不同的数据库 如何合并为一个,两个数据库都有数据,表的前缀不同,想合并为一个