Feb 17, 2007 #1 jrprogr Programmer Jul 20, 2006 74 US can we use BCP to dynamically exported the results with column headers and data of the sql query to csv file?
can we use BCP to dynamically exported the results with column headers and data of the sql query to csv file?
Feb 17, 2007 #2 mrdenny Programmer May 27, 2002 11,595 When using BCP row headers are not included. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration) MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com Upvote 0 Downvote
When using BCP row headers are not included. Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration) MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com