Query a SQL database

This script can be used to query an SQL database Script : $SqlConnection = New-Object System.Data.SqlClient.SqlConnection $SqlConnection.ConnectionString = “Server=DBServerHostname;Database=master;Integrated Security=True” $SqlConnection.Open() $SqlCmd = New-Object System.Data.SqlClient.SqlCommand $SqlCmd.CommandText = “select * from DatabaseName” $SqlCmd.Connection = $SqlConnection $reader = $SqlCmd.ExecuteReader() $Counter = $Reader.FieldCount