<div>
hi <br />
<br />
the way to do this is use a query like so:<br />

<pre><code class="code-1 nolinks" id="code-20-39746830-1"><span>  bcp &quot;select 'col1', 'col2',.. from dbo.myTableout&quot; queryout myTable.csv /SmyServer01 /c /t, -T</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
I am using following BCP command to export the SQL out put to CVS file. But it is missing the column header. How do I add the column header in the CSV out put ? &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;select @sql = 'bcp &quot;exec '+ &nbsp;'usp_EmployeeDetails]'''+ @myDate+ '''&quot; queryout ' + @Path + '.csv -c -t, -T -S'+ @@sname<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EXEC master..xp_cmdshell @sql
</div>
</div>


I am using following BCP command to export the SQL out put to CVS file. But it is missing the column header. How do I add the column header in the CSV out put ?	

	select @sql = 'bcp "exec '+  'usp_EmployeeDetails]'''+ @myDate+ '''" queryout ' + @Path + '.csv -c -t, -T -S'+ @@sname

	EXEC master..xp_cmdshell @sql

SQL QUERY TO CSV WITH COLUMN HEADER

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.