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 vote349 views2 answers
The requested url was not found on this server. apache/2.4.29 (ubuntu) server at
Shell/Bash
0 vote365 views1 answer
Install repo tool centos
Shell/Bash
18 votes348 views4 answers
Docker remove all volume
Shell/Bash
1 vote379 views1 answer
Albert for ubuntu
Shell/Bash
0 vote403 views1 answer
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
Shell/Bash
2 votes408 views1 answer
Split screen into 4 ubuntu
Shell/Bash
0 vote465 views1 answer
Update cpanel
Shell/Bash
1 vote345 views1 answer
Install polybar ubuntu 20.04
Shell/Bash
0 vote357 views1 answer
Manjaro linux system information
Shell/Bash
125 votes373 views6 answers
Install react bootstrap
Shell/Bash