如何将MySQL插入语句转换为SQL Server兼容的插入语句？

<?php
// SQL Server 连接
$conn = sqlsrv_connect('your_server_name', array('your_username', 'your_password',
    array('Database'=>'diandong')));

if ($conn === false) {
    die(print_r(sqlsrv_errors(), true));
}

// 查询SoiID (已调整为SQL Server语法)
$sql = "SELECT SoiID FROM test";
$stmt = sqlsrv_query($conn, $sql);
$arr = [];
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    $arr[] = $row['SoiID']; // 直接访问SoiID
}
sqlsrv_free_stmt($stmt);


// 预处理语句 (已调整为SQL Server语法)
$stmt = sqlsrv_prepare($conn, "INSERT INTO test (SoiID, PirName) VALUES (?, ?)");
sqlsrv_bind_param($stmt, array(&$SoiID, &$PirName), array(SQLSRV_PARAM_IN, SQLSRV_PARAM_IN));

$cansun = sqlsrv_prepare($conn, "INSERT INTO test1 (SoiID, DmgKind) VALUES (?, ?)");
sqlsrv_bind_param($cansun, array(&$SoiID, &$DmgKind), array(SQLSRV_PARAM_IN, SQLSRV_PARAM_IN));

// 插入数据
foreach ($json['Data'] as $item) {
    if (!in_array($item['SoiID'], $arr)) {
        $SoiID = $item['SoiID'];
        $PirName = $item['PirName']; // 假设item包含PirName
        $result = sqlsrv_execute($stmt);
        if ($result === false) {
            die(print_r(sqlsrv_errors(), true));
        }

        if (!empty($item['DmgInfos'])) {
            foreach ($item['DmgInfos'] as $c) {
                $DmgKind = $c['DmgKind']; // 假设c包含DmgKind
                $result = sqlsrv_execute($cansun);
                if ($result === false) {
                    die(print_r(sqlsrv_errors(), true));
                }
            }
        }
    }
}
sqlsrv_close($conn);
?>