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

0 vote123 views3 answers
Speedtest mac terminal
Shell/Bash
0 vote126 views1 answer
How to install deface makers for ubuntu
Shell/Bash
1 vote98 views1 answer
Batch directory
Shell/Bash
0 vote110 views1 answer
Manjaro gnome poweroff too long
Shell/Bash
16 votes101 views2 answers
Firebase cli windows
Shell/Bash
12 votes95 views3 answers
Vlc download for linux
Shell/Bash
1 vote93 views1 answer
How to show gpg key
Shell/Bash
50 votes97 views6 answers
Git allow unrelated histories
Shell/Bash
2 votes116 views1 answer
Error while installing psycopg2 on ubuntu 20.04
Shell/Bash
0 vote106 views1 answer
Configuring the RDS and REDIS
Shell/Bash