title: Save SELECT query output to a text file with pipe delimter
body: <pre><code>EXEC master.dbo.sp_configure 'show advanced options', 1
  RECONFIGURE
  EXEC master.dbo.sp_configure 'xp_cmdshell', 1
  RECONFIGURE 
  
  
  --EXEC master..xp_cmdshell'bcp "SELECT TOP 5 CUSTOMERID FROM Northwind.dbo.Customers" queryout "c:\text.txt" -c -T -x'
  </code></pre>
  
  <p>now i am getting the result but it is not pipe delimter  I need to get the  result  with pipe as a delimter how can i get it  done</p>
  
  <p>Thanks
  Prince</p>