如何将MySQL数据库插入代码转换为SQL Server兼容版本？

$mysqli=new mysqli('localhost','root','root');
mysqli_select_db($mysqli,'diandong');
$sql="select SoiID from test";
$res=$mysqli->query($sql);
$arr=array();
while ($row=$res->fetch_assoc()) {
    $arr[]=$row;
    // print_r($arr);
}
$res->free();
//关闭连接
$mysqli->close();
$arrs = [];
foreach ($arr as $k => $v) {
    $arrs[] = $v['SoiID'];
}


$con = mysqli_connect("localhost","root","root","diandong");

$stmt = mysqli_prepare($con, "insert into test (SoiID, PirName) values (?,?)");
mysqli_stmt_bind_param($stmt, "ss", $SoiID, $PirName);

$cansun = mysqli_prepare($con, "insert into test1 (SoiID, DmgKind) values (?,?)");
mysqli_stmt_bind_param($cansun, "ss", $SoiID, $DmgKind);

// 插入数据
foreach ($json['Data'] as $i => $item) {
    if (!in_array($item['SoiID'], $arrs)) {
        
        extract($item);
        mysqli_stmt_execute($stmt);

        if(!empty($item['DmgInfos'])) {
            foreach ($item['DmgInfos'] as $c) {
                extract($c);
                mysqli_stmt_execute($cansun);
            }
        }
    }
}