对powershell中的变量进行SQL查询

# 导入适当的数据库驱动程序
Add-Type -Path "C:\path\to\your\database\driver.dll"

# 设置数据库连接字符串
$connectionString = "Data Source=your_server;Initial Catalog=your_database;User ID=your_username;Password=your_password"

# 创建数据库连接
$connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)

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

# 创建SQL查询语句，使用变量作为查询条件
$query = "SELECT * FROM your_table WHERE column_name = '$your_variable'"

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

# 执行查询并获取结果
$result = $command.ExecuteReader()

# 遍历结果集
while ($result.Read()) {
    # 处理每一行数据
    $column1Value = $result["column1"]
    $column2Value = $result["column2"]
    # ...
}

# 关闭结果集和数据库连接
$result.Close()
$connection.Close()