$sql = " SELECT cd as [SchoolCode], nm as [SchoolName] FROM [loc] " $filename = "c:\temp\This.txt" Invoke-SqlCmd –ServerInstance "SQLSERVER" –Database "DST16000AeriesDemo" -Username "test" -Password "test" -Query $sql | Export-Csv -NoType $filename
Export a SQL query to a CSV file.
Modified on: Thu, Feb 9, 2017 at 10:42 AM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.