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

[aboys]

有两个表(ＡＢ）,字段一样
[SOPTYPE] [smallint] NOT NULL ,
[SOPNUMBE] [char] (21) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ORIGTYPE] [smallint] NOT NULL ,
[ORIGNUMB] [char] (21) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DOCID] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DOCDATE] [datetime] NOT NULL ,
[GLPOSTDT] [datetime] NOT NULL ,
[QUOTEDAT] [datetime] NOT NULL ,
[QUOEXPDA] [datetime] NOT NULL ,
[ORDRDATE] [datetime] NOT NULL ,
[INVODATE] [datetime] NOT NULL ,
[BACKDATE] [datetime] NOT NULL ,
[RETUDATE] [datetime] NOT NULL ,
[ReqShipDate] [datetime] NOT NULL ,
[FUFILDAT] [datetime] NOT NULL ,
[ACTLSHIP] [datetime] NOT NULL ,
[DISCDATE] [datetime] NOT NULL ,
[DUEDATE] [datetime] NOT NULL ,
[REPTING] [tinyint] NOT NULL ,
[TRXFREQU] [smallint] NOT NULL ,
[TIMEREPD] [smallint] NOT NULL ,
[TIMETREP] [smallint] NOT NULL ,
[DYSTINCR] [smallint] NOT NULL ,
[TYPE] [varchar](100) NOT NULL

如果TYPE的值是'UPDATE',那么以A中的数据UPDATE表B中的数据(根据唯一字段SOPTYPE),不用游标,因为这样需要定义的变量太多了

..........各位大侠献策献计吧,谢谢

[friendliu]

update b set b.SOPNUMBE=a.SOPNUMBE
.....

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

[hbwhwanghua]

两表通过一条UPDATE语句就可以了，

update a set a.字段名= b.字段名 from a,b where a.SOPTYPE = b.SOPTYPE

[pengdali]

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

[zjcxc]

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'

[nboys]

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