啊,我来晚了用8楼的merge实现会很快merge into busing (select * from a) ion (b.a = i.a and b.b = i.b)when matched then update set b.a = i.a, b.b = i.b,b.xx=i.xx wher...
显示全部啊,我来晚了
用8楼的merge实现会很快
merge into b
using (select *
from a) i
on (b.a = i.a and b.b = i.b)
when matched then
update
set b.a = i.a, b.b = i.b,b.xx=i.xx
where b.a = i.a
and b.b = i.b
when not matched then
insert values (i.a, i.b, i.xx);
收起