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

1 vote115 views1 answer
Check active number of ssh connections
Shell/Bash
7 votes186 views2 answers
How to revert back to previous commit in git permanently
Shell/Bash
14 votes135 views5 answers
Remove tracked files git
Shell/Bash
5 votes116 views2 answers
Rejected master -> master (non-fast-forward)
Shell/Bash
0 vote98 views1 answer
Laravel remote: error: unable to unlink old 'public/.htaccess': Permission denied
Shell/Bash
6 votes122 views3 answers
Screen quit session
Shell/Bash
18 votes106 views5 answers
Git stash pop single file
Shell/Bash
0 vote103 views2 answers
Vue 3 qr code reader
Shell/Bash
0 vote117 views1 answer
Git add -M meaning
Shell/Bash
2 votes74 views2 answers
Download phpmyadmin mac
Shell/Bash