【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“259.sql”一文,供大家参考学习!
merge into mr.tb_empay12 d
using mr.tb_empay07 s
on (d.WY_NUM = s.WY_NUM)
when matched then update set d.empay = d.empay + 100
when not matched then insert (d.wy_num, d.name,d.sex,d.age,d.empay)
values (s.wy_num,s.name,s.sex,s.age,s.empay+100);