sql server insert or update

MERGE INTO TargetTable WITH (UPDLOCK) AS target
USING SourceTable AS source
ON target.PrimaryKey = source.PrimaryKey
WHEN MATCHED THEN
    UPDATE SET target.Column1 = source.Column1, target.Column2 = source.Column2
WHEN NOT MATCHED THEN
    INSERT (Column1, Column2) VALUES (source.Column1, source.Column2);

-- 批量插入示例
INSERT INTO TargetTable (PrimaryKey, Column1, Column2)
SELECT PrimaryKey, Column1, Column2 FROM SourceTable
WHERE NOT EXISTS (SELECT 1 FROM TargetTable WHERE PrimaryKey = SourceTable.PrimaryKey);

-- 批量更新示例
UPDATE TargetTable
SET Column1 = SourceTable.Column1, Column2 = SourceTable.Column2
FROM TargetTable
INNER JOIN SourceTable ON TargetTable.PrimaryKey = SourceTable.PrimaryKey;