99999久久久久久亚洲,欧美人与禽猛交狂配,高清日韩av在线影院,一个人在线高清免费观看,啦啦啦在线视频免费观看www

<pre id="fn9tt"></pre><acronym id="fn9tt"></acronym>

熱線電話：13121318867

登錄

LXM21

2021-04-27 閱讀量: 2342

這個存儲代碼在mysql中應(yīng)該怎么改

CREATE PROCEDURE XSDAB_ADD
(@XH VARCHAR(20),
@XM VARCHAR(40),
@XB BIT =0,
@JG VARCHAR(20),
@BJMC VARCHAR(40),
@SZX VARCHAR(40),
@SSXY VARCHAR(40),
@DJRY VARCHAR(20)
--,@LRRQ DATETIME)
AS

 DECLARE @LRRQ DATETIME
 SET @LRRQ=GETDATE()
 INSERT INTO XSDAB(XH,XM,XB,JG,BJMC,SZX,SSXY,DJRY,LRRQ)
 VALUES(@XH,@XM,@XB,@JG,@BJMC,@SZX,@SSXY,@DJRY,@LRRQ)

修改：

DELIMITER //
CREATE PROCEDURE XSDAB_ADD
(in XH VARCHAR(20),
in XM VARCHAR(40),
in JG VARCHAR(20),
in BJMC VARCHAR(40),
in SZX VARCHAR(40),
in SSXY VARCHAR(40),
in DJRY VARCHAR(20),
in LRRQ DATETIME)
begin
 DECLARE XB BIT;
 DECLARE LRRQ DATETIME;
 SET @LRRQ=GETDATE(),@XB=0;
 INSERT INTO XSDAB(XH,XM,XB,JG,BJMC,SZX,SSXY,DJRY,LRRQ) VALUES(@XH,@XM,@XB,@JG,@BJMC,@SZX,@SSXY,@DJRY,@LRRQ);
 END //
DELIMITER ;