title: How to add text qualifier (") while exporting data using SQLCMD command?
body: <p>I am exporting data from SQL Server table to CSV using SQLCMD:</p>
  
  <pre><code>sqlcmd -S serverdetails -s"^" -d dbname -U username -P password -W -Q "SET NOCOUNT on; Select  * from table with (nolock) " &gt; c:\\USERS\\a\\b\\export_file.csv -s"^" -W """;
  </code></pre>
  
  <p>I am getting data like this: </p>
  
  <pre><code>id^column1^column2^column3^column4
  1^abc^cde^www.google.com^8776565
  2^abc^cde^www.google.com^8776565
  3^abc^cde^www.google.com^8776565
  </code></pre>
  
  <p>I want output like this: </p>
  
  <pre><code>"id"^"column1"^"column2"^"column3"^"column4"
  "1"^"abc"^"cde"^"www.google.com"^"8776565"
  "2"^"abc"^"cde"^"www.google.com"^"8776565"
  "3"^"abc"^"cde"^"www.google.com"^"8776565"
  </code></pre>
  
  <p>Please suggest how I can do this with <code>select * from table</code>. I don't want to specify all columns and concatenate <code>"</code> with them.</p>