title: exporting data from sql server into a CSV using ssms
body: <p>I need to export data from several tables in SQL Server 2008 using SSMS. I do <em>not</em> want to use the native <em>Export Data Wizard</em>; I want to use a query instead.  This means I cannot use <code>sqlcmd</code> or <code>bcp</code>.</p>
  
  <p>How can I export data out of SQL Server 2008 using a query?</p>
  
  <p>I need it to be comma delimited and double quoted as a text qualifier.</p>
  
  <p>Thanks so much for any guidance/help.</p>