数据的覆盖操作实例
MERGE INTO m_c_expense_ReportHistory ERH --目标表
USING
(SELECT ReportID , ReportName , Status ,Processor_Start_Date FROMm_c_expense_Report ) ER --数据源表
ON (ER.ReportID = ERH.ReportID)
WHEN MATCHED THEN
UPDATE SET ERH.Processor_Start_Date = ER.Processor_Start_Date ,ERH.ReportName=ER.ReportName
WHEN NOT MATCHED THEN
INSERT (ReportID , ReportName , Status ,Processor_Start_Date ) VALUES(ER.ReportID , ER.ReportName , ER.Status ,ER.Processor_Start_Date);
数据库数据的覆盖操作,满足条件则更新,不满足条件则插入。
USING
(SELECT ReportID , ReportName , Status ,Processor_Start_Date FROMm_c_expense_Report ) ER --数据源表
ON (ER.ReportID = ERH.ReportID)
WHEN MATCHED THEN
UPDATE SET ERH.Processor_Start_Date = ER.Processor_Start_Date ,ERH.ReportName=ER.ReportName
WHEN NOT MATCHED THEN
INSERT (ReportID , ReportName , Status ,Processor_Start_Date ) VALUES(ER.ReportID , ER.ReportName , ER.Status ,ER.Processor_Start_Date);
数据库数据的覆盖操作,满足条件则更新,不满足条件则插入。