prepareMerge

array public
\Bitrix\Main\DB\MssqlSqlHelper::prepareMerge(
 string $tableName,
 array $primaryFields,
 array $insertFields,
 array $updateFields
);

This non-static method builds string for SQL MERGE command for the specified table.

Parameter	Description	Version
$tableName	Table name
$primaryFields	Array of primary keys in list of column types: Array("column")[]
$insertFields	Array of what to insert: Array("column" => $value)[]
$updateFields	Array of what to update: Array("column" => $value)[]