cmd - Add Headers name in the csv -


goal:
want add name of column's header stored procedure csv file

bcp "exec [databasname].[storedprocedure]" queryout c:\test\bcp_outputtable.csv -c -t -spc01 -r\n

problem:
cannot find solution it.

info:
i'm using code above in cmd.

rename "c:\test\bcp_outputtable.csv" "c:\test\bcp_outputtable.txt" echo headrow1,headrow2,headrow3,... >"c:\test\bcp_outputtable.csv" type "c:\test\bcp_outputtable.txt>>"c:\test\bcp_outputtable.csv" del "c:\test\bcp_outputtable.txt" 

Comments

Popular posts from this blog

android - How to save instance state of selected radiobutton on menu -

python 3 IndexError: list index out of range -

IF statement in MySQL trigger -