merge into a using b on (a.a=b.b) when matched then update xxxxx when not matched then insert (xxx) values(xxx);