sql server批量同步数据MERGE INTO
MERGE INTO table_name t1 USING (SELECT * FROM table_name) t2
ON t1.column= t2.column
WHEN MATCHED THEN
UPDATE SET t1.col1 = t2.col1, t1.col2 = t2.col2
WHEN NOT MATCHED THEN INSERT (t1.col1,t1.col2) VALUES (t2.col1,t2.col2);
其中,t1为目标表,t2为数据源表。大数据情况下,直接用update从t2拉取数据给t1对服务器是一种考验,甚至死机,此方法可以提高效率