这个存储过程应该怎么写？(50分)

H

holyszq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #1

REATE PROCEDURE Save_Data
(
@GYSdm VarChar(11),--供应商代码
@LB VarChar(2),--类别号
@ZC_DH Int, --单号
)
AS
Begin
我要 UPDate SPxx Set GYSdm=@GYSdm 条件是要 SPxx 里的 SPbm= CGXX里的 SPbm
并且CGXX 的LB=@LB 和 DH=@ZC_DH 谢谢!!!
End
go

 

S

sqz

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #2

update spxx set gysdm=@gysdm from spxx,cgxx where spxx.spbm=cgxx.spbm
and cgxx.lb=@lb and cgxx.dh=@zc_dh

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #3

update spxx
set gysdm=@gysdm
from spxx a ,cgxx b
where a.spbm=b.spbm and b.lb=@lb and b.dh=@zh

 

F

fshrq1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #4

update spxx set gysdm=(select gysdm from CGXX,spxx where spxx.spbm=CGXX.spbm
and CGXX.LB=@LB and DH=@ZC_DH)

 

H

holyszq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-23

• #5

谢谢!!!