sql语句错误代码分析
CREATE PROCEDURE WEB2_EDITACCINFO@MEMB_ID NVARCHAR(10),
@MEMB_PWD NVARCHAR(10),
@MEMB_NAME NVARCHAR(10),
@ADDR_INFO NVARCHAR(50),
@MAIL_ADDR NVARCHAR(50),
@FPAS_QUES NVARCHAR(50),
@FPAS_ANSW NVARCHAR(50),
@MONEY INT,@QX CHAR(1),
@CKPWD SMALLINT,
@JF INT,
@QXEndTime Date TIME
AS
declare @SNO_NUMB varchar(15)
if(len(@ADDR_INFO) >=4)
begin
set @SNO_NUMB=`A00000` + right(@ADDR_INFO,4)
end
else
begin
set @SNO_NUMB=`A00000`
end
DECLARE @GUAUTOID BIGINT
UPDATE MEMB_INFO SET[email=QXENDTime=@QXEndTime,JF=@JF,MEMB_PWD=@MEMB_PWD,MEMB_NAME=@MEMB_NAME,PHON_NUMB=@ADDR_INFO,S]QXENDTime=@QXEndTime,JF=@JF,MEMB_PWD=@MEMB_PWD,MEMB_NAME=@MEMB_NAME,PHON_NUMB=@ADDR_INFO,S[/email][email=NO_NUMB=@SNO_NUMB,ADDR_DETA=@ADDR_INFO,MAIL_ADDR=@MAIL_ADDR,FPAS_QUES=@FPAS_QUES,FPAS_ANS]NO_NUMB=@SNO_NUMB,ADDR_DETA=@ADDR_INFO,MAIL_ADDR=@MAIL_ADDR,FPAS_QUES=@FPAS_QUES,FPAS_ANS[/email]
[email=W=@FPAS_ANSW,QX=@QX]W=@FPAS_ANSW,QX=@QX[/email] WHERE [email=MEMB_ID=@MEMB_ID]MEMB_ID=@MEMB_ID[/email]
UPDATE VI_CURR_INFO SET [email=SNO_NUMB=@ADDR_INFO]SNO_NUMB=@ADDR_INFO[/email] WHERE [email=MEMB_ID=@MEMB_ID]MEMB_ID=@MEMB_ID[/email]UPDATE WAREHOUSE SET [email=MONEY=@MONEY,PW=@CKPWD]MONEY=@MONEY,PW=@CKPWD[/email] WHERE [email=ACCOUNTID=@MEMB_ID]ACCOUNTID=@MEMB_ID[/email]
SELECT `ROWCOUNT`=1
