Example of a SQL select query using PowerShell

SelectQuery.ps1

$ServerName   = '.'
$DatabaseName = 'Demo'


function Execute-SqlQuery($query) {
   $a = @()
   try {
        $connectionString = 'Server='+$ServerName+';Database='+$DatabaseName+';Integrated Security=True;'
        $connection = New-Object System.Data.SqlClient.SqlConnection
        $connection.ConnectionString = $connectionString
        $Datatable = New-Object System.Data.DataTable
        $connection.Open()
        $sqlCommand = $connection.CreateCommand()
        $sqlCommand.CommandText = $query
        $sqlReader = $sqlCommand.ExecuteReader()
        $DataTable.Load($sqlReader)
        
        foreach ($rows in $DataTable.Rows)
        {
            $a += $rows['a']
        }
    }
    catch
    {
        throw "Error querying database"
    }
    finally {
       $connection.Dispose()
    }
    return $a
}

$SqlQuery     = 'SELECT 1 as A;'
$sqlResults = Execute-SqlQuery($SqlQuery)

foreach ($item in $sqlResults)
{
    Write-Host $item
}