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.

Answer 1

Click here on your SSMS before you execute your query.