gistfile1.txt

$connectionString = "Data Source=SQLSERVER;Initial Catalog=SYSINFO;Integrated Security=SSPI;"
#Find Connection information
#Gets system information
$os = Get-WmiInfo Win32_OperatingSystem
#loads the part of the .NET Framework that’s responsible for working with databases
[assembly.reflection]::loadwithpartialname('System.Data')
#Create new connection to database
$conn = New-Object System.Data.SqlClient.SqlConnection
$conn.ConnectionString = $connectionString
$conn.open()
#Creates sql command
$cmd = New-Object System.Data.SqlClient.SqlCommand
$cmd.connection = $conn
$cmd.commandtext = $query

#$cmd.executenonquery()
$queryResult = $cmd.ExecuteReader()
$conn.close()