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

IF statement in MySQL trigger -

c++ - What does MSC in "// appease MSC" comments mean? -

javascript - Blogger related post gadget image Resize s72-c [ Need Expert Help ] -