大伙看看,如何实现这个功能呢?

Question

update b set b.SOPNUMBE=a.SOPNUMBE
             .....from a where (a.type='update' and a.soptye=b.soptype

Answer 1

两表通过一条UPDATE语句就可以了，update a set a.字段名= b.字段名 from a,b where a.SOPTYPE = b.SOPTYPE

Answer 2

update B set SOPNUMBE=a.SOPNUMBE,ORIGTYPE=a.ORIGTYPE,ORIGNUMB=a.ORIGNUMB,DOCID=a.DOCID,
DOCDATE=a.DOCDATE,GLPOSTDT=a.GLPOSTDT,QUOTEDAT=a.QUOTEDAT,QUOEXPDA=a.QUOEXPDA,ORDRDATE=a.ORDRDATE
INVODATE=a.INVODATE,BACKDATE=a.BACKDATE,RETUDATE=a.RETUDATE,ReqShipDate=a.ReqShipDate,FUFILDAT=a.FUFILDAT
,ACTLSHIP=a.ACTLSHIP,DISCDATE=a.DISCDATE,DUEDATE=a.DUEDATE,REPTING=a.REPTING,TRXFREQU=a.TRXFREQU,TIMEREPD=a.TIMEREPD
,TIMETREP=a.TIMETREP,DYSTINCR=a.DYSTINCR,TYPE=a.TYPE
from a where a.SOPTYPE=b.SOPTYPE

Answer 3

update b set
[SOPTYPE]=a.[SOPTYPE]
,[SOPNUMBE]=a.[SOPNUMBE]
,[ORIGTYPE]=a.[ORIGTYPE]
,[ORIGNUMB]=a.[ORIGNUMB]
,[DOCID]=a.[DOCID]
,DOCDATE]=a.[DOCDATE]
,GLPOSTDT]=a.[GLPOSTDT]
,QUOTEDAT]=a.[QUOTEDAT]
,QUOEXPDA]=a.[QUOEXPDA]
,ORDRDATE]=a.[ORDRDATE]
,INVODATE]=a.[INVODATE]
,BACKDATE]=a.[BACKDATE]
,RETUDATE]=a.[RETUDATE]
,ReqShipDate]=a.[ReqShipDate]
,FUFILDAT]=a.[FUFILDAT]
,ACTLSHIP]=a.[ACTLSHIP]
,DISCDATE]=a.[DISCDATE]
,DUEDATE]=a.[DUEDATE]
,REPTING]=a.[REPTING]
,TRXFREQU]=a.[TRXFREQU]
,TIMEREPD]=a.[TIMEREPD]
,TIMETREP]=a.[TIMETREP]
,DYSTINCR]=a.[DYSTINCR]
,TYPE]=a.[TYPE]
from a,b where a.SOPTYPE=b.SOPTYPE  and a.type='update'

Answer 4

update b set b.SOPNUMBE=a.SOPNUMBE..............
 from a join b on a.SOPTYPE = b.SOPTYPE