如何使用PowerShell从存储过程返回多个记录集

# 连接到数据库
$serverName = "数据库服务器名称"
$databaseName = "数据库名称"
$credentials = Get-Credential
$connString = "Server=$serverName;Database=$databaseName;Integrated Security=False;User ID=$($credentials.UserName);Password=$($credentials.GetNetworkCredential().Password)"
$connection = New-Object System.Data.SqlClient.SqlConnection($connString)
$connection.Open()

# 执行存储过程
$cmd = New-Object System.Data.SqlClient.SqlCommand
$cmd.Connection = $connection
$cmd.CommandText = "存储过程名称"
$cmd.CommandType = [System.Data.CommandType]::StoredProcedure

# 添加存储过程参数
$cmd.Parameters.AddWithValue("@参数名称", $参数值)

# 执行存储过程并获取结果
$reader = $cmd.ExecuteReader()

# 处理多个记录集
$recordSetIndex = 0
do {
    Write-Host "处理记录集 $($recordSetIndex + 1)"
    while ($reader.Read()) {
        # 处理每一行数据
        $columnValue = $reader.GetValue($列索引)
        Write-Host $columnValue
    }

    $recordSetIndex++
} while ($reader.NextResult())

# 清理资源
$reader.Close()
$connection.Close()