不存在就插入insert？
先判断是否存在，存在就更新IF EXISTS(SELECT 1 FROM sys_emp a,inserted b join hr_emp_title c on b.empid = c.empid)BEGINupdate c set c.title_code = b.title_codefrom inserted b join hr_emp_title c on b.empid = c.empid END不存在就插入ELSEBEGINinsert into hr_emp_title(empid,title_code) select empid ,title_code from inserted;END
