title: How to get export output in "real" CSV format in SQL Server Management Studio?
body: <p>I have a query that I am running in SQL Server Management Studio (connecting to a SQL Server 2005 database). I want to export the data in CSV format. Not wannabe CSV format, where you just stick a comma between each column, but "real" CSV format, where you put quotes around your strings. This way you can export data that has commas or quotes in it.</p>
  
  <p>All the examples I see limit themselves to the wannabe format. I can't figure out where the option to quote strings is.</p>
  
  <p>If SSMS is truly incapable of this basic feat, are there other tools that will do it easily? I don't want to have to write a C# program every time I need a data dump.</p>