#Function which connects to SQL server and DB, queries it and returns result as object
Function sql($sqlText, $database, $server)
{
$connection = new-object System.Data.SqlClient.SQLConnection("Data Source=$server;Integrated Security=SSPI;Initial Catalog=$database");
$cmd = new-object System.Data.SqlClient.SqlCommand($sqlText, $connection);
$connection.Open();
$reader = $cmd.ExecuteReader()
$results = @()
while ($reader.Read())
{
$row = @{}
for ($i = 0; $i -lt $reader.FieldCount; $i++)
{
$row[$reader.GetName($i)] = $reader.GetValue($i)
}
$results += new-object psobject -property $row
}
$connection.Close();
$results
}
$sqlResults = @()
$server = "ServerName"
$database = "DB Name"
$sqlText = "SELECT STOCK.STOCK_CODE, STOCK.DESCRIPTION, STOCK.UNIT_OF_SALE, STOCK.NOMINAL_CODE, STOCK.PURCHASE_REF, STOCK.SUPPLIER_PART_NUMBER, STOCK.LOCATION, STOCK.COMMODITY_CODE, STOCK.SALES_PRICE, STOCK.WEB_DESCRIPTION, STOCK.WEB_DETAILS, STOCK.WEB_CATEGORY_1, STOCK.WEB_CATEGORY_2, STOCK.WEB_CATEGORY_3, STOCK.WEB_IMAGE_FILE, STOCK.WEB_PUBLISH, STOCK.WEB_SPECIAL, STOCK.INTRASTAT_COMM_CODE, STOCK.IGNORE_STK_LVL_FLAG, STOCK.DEPT_NUMBER, STOCK.DEPT_NAME, STOCK.TAX_CODE, STOCK.ASSEMBLY_LEVEL, STOCK.LINK_LEVEL, STOCK.STOCK_CAT, STOCK.STOCK_CAT_NAME, STOCK.STOCK_TAKE_DATE, STOCK.LAST_PURCHASE_PRICE, STOCK.LAST_DISC_PURCHASE_PRICE, STOCK.AVERAGE_COST_PRICE, STOCK.QTY_IN_STOCK, STOCK.QTY_ON_ORDER, STOCK.QTY_ALLOCATED, STOCK.QTY_LAST_ORDER, STOCK.QTY_REORDER, STOCK.QTY_REORDER_LEVEL, STOCK.QTY_LAST_STOCK_TAKE, STOCK.QTY_MAKEUP, STOCK.LAST_SALE_DATE, STOCK.LAST_PURCHASE_DATE, STOCK.UNIT_WEIGHT, STOCK.HAS_NO_COMPONENT, STOCK.HAS_BOM, STOCK.INACTIVE_FLAG
FROM STOCK STOCK
WHERE (STOCK.INACTIVE_FLAG=0)
ORDER BY STOCK.STOCK_CODE"
$sqlResults = sql $sqlText $database $server
$sqlResults | Export-Csv "Path\filename.csv" -NoTypeInformation
. The best part is that it doesn't warn you it's going to delete your query when you switch to another connection 
.
