update b set cInvCCode=a.cInvCCode from 表1 a,表2 b where a.cInvCode=b.cInvCode
update b set b.cInvCCode=a.cInvCCode from 表1 as a inner join 表2 as b on a.cInvCode=b.cInvCode
update 表2 set cInvCCode=(select表1.cInvCCode from 表1 where 表1.cInvCCode=表2.cInvCCode)
select identity(int,1,1) as NEWID,a.* into #temp from 表2 order by IDupdate #temp set a.cInvCCode = b.cInvCCode from #temp a,表1 b where a.newid = b.idupdate 表2 set a.cInvCCode = b.cInvCCode from 表1 a,#temp b, where a.id = b.newiddrop table #temp
晕,又看错了,faint~update 表2 set set a.cInvCCode = b.cInvCCode from 表2 a,表1 b where a.cInvCode = b.cInvCode
update t2 set t2.cInvCCode=t1.cInvCCode from t1,t2 where t1.cInvCode=t2.cInvCode
update b set cInvCCode=a.cInvCCode from 表1 a left join 表2 b on a.cInvCode=b.cInvCode
update 表2 set cInvCCode=表1.cInvCCode from 表1 where 表2.cInvCode=表1.cInvCode
update 表2 set cInvCCode=表1.cInvCCode from 表1 where 表2.cInvCode=表1.cInvCode
update 表2 set cinvccode=表1.cinvccode from 表1,表2 where 表1.cinvcode=表2.cinvcode
from 表1 a,表2 b
where a.cInvCode=b.cInvCode
from 表1 as a inner join 表2 as b
on a.cInvCode=b.cInvCode
set a.cInvCCode = b.cInvCCode
from #temp a,表1 b
where a.newid = b.idupdate 表2
set a.cInvCCode = b.cInvCCode
from 表1 a,#temp b,
where a.id = b.newiddrop table #temp
set set a.cInvCCode = b.cInvCCode
from 表2 a,表1 b
where a.cInvCode = b.cInvCode
set t2.cInvCCode=t1.cInvCCode
from t1,t2
where t1.cInvCode=t2.cInvCode
from 表1 a left join 表2 b
on a.cInvCode=b.cInvCode
from 表1
where 表2.cInvCode=表1.cInvCode
from 表1
where 表2.cInvCode=表1.cInvCode