Update #FEfl0001 set f_dxbh1=a.dxlb1,f_dxlb2=a.dxlb2
,f_dxlb3=a.dxlb3,f_kmbh=a.kmbh
,f_bbh=a.bbh,f_lbmc =a.lbmc
from lskmlb a ,#FEfl0001 b where a.关键字=b.关键字
,f_dxlb3=a.dxlb3,f_kmbh=a.kmbh
,f_bbh=a.bbh,f_lbmc =a.lbmc
from lskmlb a ,#FEfl0001 b where a.关键字=b.关键字
1. 先删除表后添加
drop #FEfl0001
go
select * into #FEfl0001 from lskmlb2.存储过程
......3.用cursor
......
set f_dxbh1=a.dxlb1,f_dxlb2=a.dxlb2
,f_dxlb3=a.dxlb3,f_kmbh=a.kmbh
,f_bbh=a.bbh,f_lbmc =a.lbmc
from lskmlb a
,f_dxbh2=b.dxlb2
,f_dxbh3=b.dxlb3
,f_kmbh=b.kmbh
,f_kmlb=b.bbh
,f_lbmc=b.lbmc
from #FEfl0001 a,lskmlb b
where 关联条件