How to output Query results to text file using bcp and queryout

Question: How can I output query results to a text file? I’ve tried    Select * from myTable into 'c:\my.txt' and  it errors.

Answer:   You can use bcp and the queryout option.   The queryout option copies from a query and is required when bulk copying data from a query.

An example of bcp and queryout

EXEC master..xp_cmdshell'bcp "SELECT  *  FROM MyTable" queryout "c:\mytext.txt" -c -T -x'

If xp_cmdshell is unavailable , a quick and dirty fix is the SSMS query output option to a text file

Read More on exporting data

SQL Server – Powershell Excel to HTML - SQL Server DBA

Export Excel data to SQL Server with Powershell - SQL Server DBA

Powershell - run script on all sql servers - SQL Server DBA

Export-CSV Powershell - SQL Server DBA