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

11 votes222 views2 answers
Install pandas conda
Shell/Bash
0 vote236 views1 answer
Teststand enter non ascci
Shell/Bash
1 vote232 views1 answer
Linux document root
Shell/Bash
17 votes237 views3 answers
Remove docker volume
Shell/Bash
0 vote242 views1 answer
Cherry pick from another repository
Shell/Bash
0 vote225 views1 answer
Target DEP-11-icons-small (stable/dep11/icons-48x48.tar) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_download_docker_com_linux_ubuntu-groovy.list:1 and /etc/apt/sources.list.d/docker-ce.list:1
Shell/Bash
0 vote222 views1 answer
How to mount a flash drive in wsl
Shell/Bash
0 vote235 views1 answer
Fix dual boot time ubuntu
Shell/Bash
0 vote241 views1 answer
Install openvpn acces 2.5.2
Shell/Bash
35 votes223 views3 answers
How to install brew on mac
Shell/Bash