Powershell追加到SQL返回的查询

# 导入System.Data.SqlClient命名空间
Add-Type -Path "C:\path\to\System.Data.dll"

# 创建SQL连接字符串
$connectionString = "Server=myServerAddress;Database=myDatabase;User Id=myUsername;Password=myPassword;"

# 创建SQL连接对象
$connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)

# 打开数据库连接
$connection.Open()

# 创建SQL查询语句
$query = "SELECT * FROM table1"

# 创建SQL命令对象
$command = New-Object System.Data.SqlClient.SqlCommand($query, $connection)

# 执行SQL查询，将结果存储在DataReader中
$reader = $command.ExecuteReader()

# 创建一个数组用于存储查询结果
$results = @()

# 将查询结果逐行追加到数组中
while ($reader.Read()) {
    $result = @{
        Column1 = $reader["Column1"]
        Column2 = $reader["Column2"]
    }
    $results += $result
}

# 关闭DataReader和数据库连接
$reader.Close()
$connection.Close()

# 创建另一个SQL查询语句
$appendQuery = "SELECT * FROM table2"

# 将查询结果追加到现有的查询结果中
$results += Invoke-Sqlcmd -Query $appendQuery -ConnectionString $connectionString

# 输出最终的查询结果
$results