PowerShell :：SQL SELECT仅返回第一行

$connectionString = "Data Source=<数据库地址>;Initial Catalog=<数据库名称>;User ID=<用户名>;Password=<密码>"
$connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)
$query = "SELECT TOP 1 * FROM <表名>"
$command = New-Object System.Data.SqlClient.SqlCommand($query, $connection)

$connection.Open()
$result = $command.ExecuteReader()

if ($result.HasRows) {
    while ($result.Read()) {
        # 处理第一行数据
        $column1Value = $result.GetValue(0)
        $column2Value = $result.GetValue(1)
        # 其他列的值以此类推
        Write-Host "Column1: $column1Value, Column2: $column2Value"
    }
} else {
    Write-Host "No rows found."
}

$connection.Close()