34,590
社区成员
发帖
与我相关
我的任务
分享
select identity(int,1,1) as id ,* into #1 from a
select identity(int,1,1) as id ,* into #2 from b
update j
set f1=d2
from #1 j ,#2 k
where j.id=k.id
update a
set f1=j.f1
from #1 j
where a.f2=j.f2
INSERT A(F1) SELECT D2 FROM B
update a
set f1=d2
from b ,a
where b.d1=a.f1
update a
set f1=d2
from b ,a
where b.d1=a.f1
update a
set f1=d2
from b ,a
where b.d1=a.f1
update a
set f1=d2
from b ,a
wher b.d1=a.f1
insert into a(f1) SELECT d1 from b