Export table to file with column headers (column names) using the bcp utility and SQL Server 2008
This method automatically outputs column names with your row data using BCP. The script writes one file for the column headers (read from INFORMATION_SCHEMA.COLUMNS table) then appends another file with the table data. The final output is combined into TableData.csv which has the headers and row data. Just replace the environment variables at the top … Read more