gistfile1.txt

function selectPOSData ($Server, $Database, $SQLQuery, $Username, $Password) {
    $Connection = New-Object System.Data.SQLClient.SQLConnection
    $Connection.ConnectionString = "server='$Server';database='$Database';User ID= $Username; Password= $Password;"
    $Connection.Open()
    $Command = New-Object System.Data.SQLClient.SQLCommand
    $Command.Connection = $Connection
    $Command.CommandText = $SQLQuery
    
    $Reader = $Command.ExecuteReader()
    while ($Reader.Read())
    {
         $Reader.GetValue($1)
    }
    $Connection.Close()
}