如何在PHP中的MSSQL中获取插入ID？

<?php
$serverName = "serverName";
$connectionOptions = array(
    "Database" => "databaseName",
    "Uid" => "username",
    "PWD" => "password"
);

// 连接到MSSQL数据库
$conn = sqlsrv_connect($serverName, $connectionOptions);

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

// 插入数据
$sql = "INSERT INTO tableName (column1, column2) VALUES ('value1', 'value2')";
$insertQuery = sqlsrv_query($conn, $sql);

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

// 获取插入ID
$sql = "SELECT @@IDENTITY AS 'InsertedID'";
$insertIDQuery = sqlsrv_query($conn, $sql);

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

// 打印插入ID
while($row = sqlsrv_fetch_array($insertIDQuery, SQLSRV_FETCH_ASSOC)) {
    echo "Inserted ID: " . $row['InsertedID'];
}

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

<?php
$serverName = "serverName";
$connectionOptions = array(
    "Database" => "databaseName",
    "Uid" => "username",
    "PWD" => "password"
);

// 连接到MSSQL数据库
$conn = sqlsrv_connect($serverName, $connectionOptions);

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

// 插入数据
$sql = "INSERT INTO tableName (column1, column2) VALUES ('value1', 'value2')";
$insertQuery = sqlsrv_query($conn, $sql);

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

// 获取插入ID
$sql = "SELECT SCOPE_IDENTITY() AS 'InsertedID'";
$insertIDQuery = sqlsrv_query($conn, $sql);

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

// 打印插入ID
while($row = sqlsrv_fetch_array($insertIDQuery, SQLSRV_FETCH_ASSOC)) {
    echo "Inserted ID: " . $row['InsertedID'];
}

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