How to save SQL Server query results to text?

Go to Tools > Options > Query Results > SQL Server > Results To Text. Then on right hand side, change output format to comma delimited. Run your query and then right click on results and click save results to file.
For More Information Please Refer:
You May Also Like to Read: