使用sqlsrv_query的多重插入

$serverName = "your_server_name";
$connectionOptions = array(
    "Database" => "your_database_name",
    "Uid" => "your_username",
    "PWD" => "your_password"
);

// 建立连接
$conn = sqlsrv_connect($serverName, $connectionOptions);

// 检查连接是否成功
if ($conn === false) {
    die(print_r(sqlsrv_errors(), true));
}

// 准备插入的数据
$data = array(
    array('John', 'Doe', 'john@example.com'),
    array('Jane', 'Smith', 'jane@example.com'),
    array('Mike', 'Johnson', 'mike@example.com')
);

// 构建插入语句
$sql = "INSERT INTO your_table_name (first_name, last_name, email) VALUES (?, ?, ?)";

// 执行插入
$stmt = sqlsrv_prepare($conn, $sql, array(&$firstName, &$lastName, &$email));

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

foreach ($data as $row) {
    $firstName = $row[0];
    $lastName = $row[1];
    $email = $row[2];

    // 执行插入
    if (sqlsrv_execute($stmt) === false) {
        die(print_r(sqlsrv_errors(), true));
    }
}

// 关闭连接
sqlsrv_close($conn);