Xp_cmdshell bcp

EXEC xp_cmdshell 'bcp "select * from (select ''a_id'' as a_id,''b_id'' as b_id,''c_id'' as c_id union select a_id,b_id,c_id from tablename)q order by case a_id when ''a_id'' then 0 ELSE 1 END" queryout "\\networkpath\a.txt" -c -Uusername -Ppassword -Sservername -ddatabasename'

Source: stackoverflow.com

Similar codes

3 votes244 views1 answer
Cmake: not found
Shell/Bash
2 votes227 views2 answers
Zsh check if file exists
Shell/Bash
1 vote236 views1 answer
How to install libpq
Shell/Bash
0 vote219 views1 answer
Ping command output to null in linux
Shell/Bash
1 vote230 views1 answer
Brew install rcp on mac
Shell/Bash
0 vote219 views0 answer
Shell/Bash
0 vote223 views1 answer
Install caprine linux
Shell/Bash
14 votes250 views6 answers
How to untrack files in git
Shell/Bash
0 vote236 views1 answer
Install rtools rstudio
Shell/Bash
0 vote220 views1 answer
Install pyaudio in pycharm
Shell/Bash