Equivalent MS SQL to the INTO OUTFILE MySQL command

• julien.dutel

  SSC-Addicted

  Points: 471

  More actions

  May 15, 2012 at 7:10 am

  #256513

  In MS SQL 2008 is there an equivalent to the MySQL command :

  SELECT * FROM test_tbl

  INTO OUTFILE 'c:/out.csv'

• Geoff A

  SSChampion

  Points: 11511

  More actions

  May 15, 2012 at 7:15 am

  #1487656

  if you are using SSMS, you can just choose "Results to" --> Results to File. you right click on the TSQL window to see that.

  or, you use sqlcmd

  sqlcmd -Q "SELECT * FROM test_tbl" -o MyOutput.txt

• rajumyd

  SSC Enthusiast

  Points: 184

  More actions

  March 14, 2014 at 12:57 am

  #1697039

  HI,

  without any manual interaction, i want to save a query output a text/csv file in my SQL database

  Example:

  SELECT * FROM ORDERS -- which is returning 25 rows

  i want save these 25 records as a text/csv file as a stream in another table at back end only.