2012年3月27日星期二

bcp with table name

HI,
i want to export data from a sql table to a csv file with a the name of each colunms in the csv file
i use this script

bcp [databasename.owner.table ]out [path.csv] -t, -c -Uuser -Ppass -Sservername

i want to put each column name in my csv file.

Sorry for my english, i'm not fluency in english

Thanks,
PatrickUse OSQL instead.|||Use DTS, you can export the data to a CSV file and I believe there is an option to include headers (column headers) into the CSV file.

没有评论:

发表评论