SQL Server query result to file

Question

How can I save query result into file from sqsh console?

Google is talking about some gui tools I don't want to use.

PS: Linux

score 5 · Answer 1 · answered Feb 16 '12 at 12:48

5

You may also redirect output to files and (if you are careful) can redirect input from files:
1> select * from sysobjects    
2> go 2>/dev/null >/tmp/objects.txt

answered Feb 16 '12 at 12:48

Ocaso Protal

19,362
8
76
83

score 4 · Accepted Answer · answered Feb 16 '12 at 12:36

4

I'm not familiar with sqsh but if it's a console tool, can you just pipe the output to a file?

sqsh <mycommand> >output.txt

answered Feb 16 '12 at 12:36

njr101

9,499
7
39
56

1

`sqsh -m csv -C "select * from ..." >output.csv` – lclark Apr 28 '12 at 20:24

score 2 · Answer 3 · answered Feb 16 '12 at 12:34

2

Not familiar with that "sqsh" shell you're talking about.... but on Windows, you could use the command-line sqlcmd tool and execute a query against SQL Server, and capture the output into a file.

See:

answered Feb 16 '12 at 12:34

marc_s

732,580
175
1,330
1,459

@fl00r: stuff like that should be put in your original question from the get go! – marc_s Feb 16 '12 at 13:10

SQL Server query result to file

3 Answers3