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 vote172 views2 answers
Kali linux vdi
Shell/Bash
1 vote176 views1 answer
Add a new branch and switch to that branch
Shell/Bash
2 votes147 views2 answers
Error response from daemon: open \\.\pipe\docker_engine_linux: The system cannot find the file specified.
Shell/Bash
11 votes164 views4 answers
Apt remove ppa
Shell/Bash
0 vote173 views1 answer
Install opencl headers ubuntu
Shell/Bash
0 vote147 views1 answer
Mjml watch command
Shell/Bash
0 vote159 views4 answers
How to install alfa 1900 driver on ubuntu
Shell/Bash
10 votes183 views6 answers
Listen EADDRINUSE: address already in use :::8081
Shell/Bash
1 vote157 views2 answers
Ubuntu kill process for user
Shell/Bash
1 vote141 views1 answer
Pip problem linux
Shell/Bash