====== Export data from MSSQL to csv with Powershell ======
  * Useful when you need to export data from MSSQL into csv with a script.

  * At first you need to add sql server snapin.
<code ps1>
add-pssnapin sqlserverprovidersnapin100
add-pssnapin sqlservercmdletsnapin100
</code>

  * Now you can export your data.
<code ps1>
$Server = "serverName"
$DBName = "dataBase"
$QueryFmt= "SELECT * FROM Mytable"

$OutputFile = "output.csv"


Invoke-Sqlcmd -ServerInstance $Server -Database $DBName -Query $QueryFmt | Export-CSV $OutputFile
</code>