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

高手帮帮忙  很急在线等

等答案中、、、、、

谢谢啊   有时间可以交流一下

至于你的要求  真的不好意思

这是商业机密，望体谅!