title: Microsoft SQL Server Management Studio - query result as text
body: <p>I have a database in Microsoft SQL Server and I am using Microsoft SQL Server Management Studio.</p>
  
  <p>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.</p>
  
  <p>It looks like this</p>
  
  <pre><code>select * from table_name
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>18 182 3386 NULL
  18 790 12191 NULL
  </code></pre>
  
  <p>In File:</p>
  
  <pre><code>18          182         3386        NULL
  18          790         12191       NULL
  </code></pre>
  
  <p>Is there any possibility to modify query so after every record it will put a special char, like this:</p>
  
  <p>In File:</p>
  
  <pre><code>18;          182;         3386;        NULL;
  18;          790;         12191;       NULL;
  </code></pre>
  
  <p>It will be easier then for me to copy this database to other programs.</p>