title: Is there a SELECT ... INTO OUTFILE equivalent in SQL Server Management Studio?
body: <p>MySQL had a nifty command <code>SELECT ... INTO OUTFILE</code> that could write the result set into a file (CSV format or some other optional format). </p>
  
  <p>I am currently using SQL Server Management Studio to query an MS-SQL backend server. I have multiple SQL queries and would like to write the output result set into a file. Is there any way I could store the results from a query directly into a file?</p>