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
Post a Comment