I am using bcp to get the query output in excel file. But I am not able to see the column headings. Is there a way to get the column heading also in the output file.

the command I am using is this.

declare @x varchar(300)

set @x = 'bcp "select * from Northwind..orders" queryout c:\test.csv -S local -U sa -P passwd -c -C RAW -t "," -r \n'

exec master..xp_cmdshell @x

go