Microsoft SQL Server Management Studio - query result as text

Question

I have a database in Microsoft SQL Server and I am using Microsoft SQL Server Management Studio.

I have an option to insert the query result to the file, although the results of the query are not separated by any special signs.

It looks like this

select * from table_name

Output:

18 182 3386 NULL
18 790 12191 NULL

In File:

18          182         3386        NULL
18          790         12191       NULL

Is there any possibility to modify query so after every record it will put a special char, like this:

In File:

18;          182;         3386;        NULL;
18;          790;         12191;       NULL;

It will be easier then for me to copy this database to other programs.

Edit > Find and Replace > Regex replace `\t` with `;\t` and `\n` with `\n;`. — Dai, Nov 15 '13 at 23:41

score 37 · Answer 1 · answered Nov 15 '13 at 23:44

37

Click here

Click here on your SSMS before you execute your query.

answered Nov 15 '13 at 23:44

M.Ali

This is what I had accidentally hit! Hart CO's answer was set correctly in my options but the button above was toggled to text response. – BYUDigger Oct 25 '19 at 22:33

score 17 · Accepted Answer · answered Nov 15 '13 at 23:41

17

In SSMS:

Tools > Options > Query Results > Results To Text

Top option there is Output Format, can set a delimiter there.

answered Nov 15 '13 at 23:41

Hart CO

score 8 · Answer 3 · answered Feb 13 '20 at 11:13

8

CTRL+T Then Execute , = Text Result CTRL+D Then Execute , = Grid Result

answered Feb 13 '20 at 11:13

Mitchell Pillay

This is what I needed! For some reason it seems that if you used the key commands (which I did by mistake), setting through Query Results in Tools doesn't fix it. I had to use CTRL+D to get out of text results. – LeftOnTheMoon Mar 06 '20 at 02:22

3 Answers3