How to add parameters into a WebRequest?

Take a look at this link: http://stackoverflow.com/questions/3279888/how-to-add-parameters-into-a-webrequest

Conditional Logic in PowerShell

http://www.powershellpro.com/powershell-tutorial-introduction/powershell-tutorial-conditional-logic/

Operator	Description
-eq	Equal to
-lt	Less than
-gt	Greater than
-ge	Greater than or Eqaul to
-le	Less than or equal to
-ne	Not equal to

perator	Description
-not	Not
!	Not
-and	And
-or	Or

Query SQL in Powershell

The following snippet will query data from SQL into DataSet format:

$ServerName = "_ServerName_"
$DatabaseName = "_DatabaseName_"
$Query = "SELECT * FROM Table WHERE Column = 'XXX'"

#Timeout parameters
$QueryTimeout = 120
$ConnectionTimeout = 30

#Action of connecting to the Database and executing the query and returning results if there were any.
$conn=New-Object System.Data.SqlClient.SQLConnection
$ConnectionString = "Server={0};Database={1};Integrated Security=True;Connect Timeout={2}" -f $ServerName,$DatabaseName,$ConnectionTimeout
$conn.ConnectionString=$ConnectionString
$conn.Open()
$cmd=New-Object system.Data.SqlClient.SqlCommand($Query,$conn)
$cmd.CommandTimeout=$QueryTimeout
$ds=New-Object system.Data.DataSet
$da=New-Object system.Data.SqlClient.SqlDataAdapter($cmd)
[void]$da.fill($ds)
$conn.Close()
$ds.Tables

From <http://stackoverflow.com/questions/8423541/how-do-you-run-a-sql-server-query-from-powershell>