How to save MSSQL query output to .txt or .json file?

Question

How to save output of a Select query to a .json file or .txt file?using MSSQL Server

Table A contains id,name,address

I tried the query below,

SELECT * from A INTO OUTFILE '/tmp/orders.txt';

but it produced an Error,

SQL Error [156] [S0001]: Incorrect syntax near the keyword 'INTO'.
  Incorrect syntax near the keyword 'INTO'.

How do i resolve the error?. Even if it's only possible to store the data in a .txt file, it will be okay.

Thanks in advance.

possible duplicate : https://stackoverflow.com/questions/262924/how-to-export-dump-a-mysql-table-into-a-text-file-including-the-field-names-a — Suresh Kamrushi, Sep 11 '18 at 11:52
I think that this question is already answered here: https://stackoverflow.com/questions/21253704/how-to-save-mysql-query-output-to-excel-or-txt-file — LePanz, Sep 11 '18 at 11:53
i require to create .json file if not possible then .txt file is okay @LePanz — R.Gopalakrishnan, Sep 11 '18 at 11:56
@R.Gopalakrishnan check my answer https://stackoverflow.com/a/52275272/2469308 - if it works for you, please consider accepting it :) — Madhur Bhaiya, Sep 11 '18 at 11:57

Madhur Bhaiya · Accepted Answer · 2018-09-11T12:16:09.787

4

As per the original question, which was tagged as MySQL: Your syntax is wrong. As per MySQL Documentation, FROM clause comes after INTO OUTFILE clause. Following should work in MySQL:

SELECT * INTO OUTFILE '/tmp/orders.txt'
FROM A

In order to get Comma-separated values in the text file, you can do the following instead (in MySQL):

SELECT * INTO OUTFILE '/tmp/orders.txt' 
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM A;

For MS SQL Server: There is no INSERT INTO OUTFILE clause available. Instead, a different solution is proposed using SQL Server Management Studio at: https://stackoverflow.com/a/6354143/2469308

edited Sep 11 '18 at 12:16

answered Sep 11 '18 at 11:52

Madhur Bhaiya

28,155
10
49
57

SQL Error [102] [S0001]: Incorrect syntax near '/tmp/orders.txt'. Incorrect syntax near '/tmp/orders.txt'. Incorrect syntax near '/tmp/orders.txt'. – R.Gopalakrishnan Sep 11 '18 at 11:59
i try it@Madhur Bhaiya – R.Gopalakrishnan Sep 11 '18 at 12:00
I try both ways Same Error will be come.@MadhurBhaiya – R.Gopalakrishnan Sep 11 '18 at 12:04
@R.Gopalakrishnan What is your Mysql version ? are you sure that you are on mysql ? – Madhur Bhaiya Sep 11 '18 at 12:04
Based on your error, I think you are on MS SQL Server , not Mysql – Madhur Bhaiya Sep 11 '18 at 12:06
Yes!!@Madhur Bhaiya – R.Gopalakrishnan Sep 11 '18 at 12:08
I'm using MS SQL Server@Madhur Bhaiya – R.Gopalakrishnan Sep 11 '18 at 12:10
1

@R.Gopalakrishnan for MS SQL Server, please check this answer: https://stackoverflow.com/a/6354143/2469308 There is no SELECT INTO OUTFILE in MS Sql server – Madhur Bhaiya Sep 11 '18 at 12:11
1

Thanks!!@Madhur Bhaiya – R.Gopalakrishnan Sep 11 '18 at 12:15

How to save MSSQL query output to .txt or .json file?

1 Answers1