Powershell SQL SELECT输出到变量

或者，如果您要查找简单的返回值而不是表以供以后处理，则可以使用以下代码。

[string] $Server= "10.0.100.1",[string] $Database = "Database123",[string] $SQLQuery= $("SELECt [FeedID] FROM [dbo].[FeedList] WHERe [FeedFileName] = 'filename.txt'")function GenericSqlQuery ($Server, $Database, $SQLQuery) {    $Connection = New-Object System.Data.SQLClient.SQLConnection    $Connection.ConnectionString = "server='$Server';database='$Database';trusted_connection=true;"    $Connection.Open()    $Command = New-Object System.Data.SQLClient.SQLCommand    $Command.Connection = $Connection    $Command.CommandText = $SQLQuery    $Reader = $Command.ExecuteReader()    while ($Reader.Read()) {         $Reader.GetValue(0)    }    $Connection.Close()}