title: BCP export sql query to csv issue
body: <p>I am trying to use the bcp command in sql to export a query result to a csv file. Although the stored procedure executes the file is never created and I receive these two results in SSMS:</p>
  
  <p><img src="https://i.stack.imgur.com/HoKcI.png" alt="enter image description here"></p>
  
  <p>Not sure what the No Column name result is from, and the second table result appears to be all the options available to the bcp command. If someone can enlighten me as to why this is happening and point me in the right direction to get the file created I would be grateful.</p>
  
  <p>Note: the Select is just a placeholder until the file creation works.</p>
  
  <p>opps the extra \ before the c: wasn't always there so it wasn't that</p>
  
  <p>I did switch to this, but still get the same results as the image without and output file:</p>
  
  <pre><code>DECLARE @H VARCHAR(2) = 'HI'
  exec xp_cmdshell 'bcp "SELECT @H AS Place"
  queryout 
  "c:\drew.txt"
  -c -T'
  </code></pre>