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 vote353 views1 answer
Chrome oninstalled run on every update
Shell/Bash
0 vote310 views1 answer
Find the pid for a port linux
Shell/Bash
0 vote327 views1 answer
How to install kivy.app
Shell/Bash
0 vote328 views1 answer
Fail2ban apt
Shell/Bash
2 votes353 views1 answer
Ionic cordova sign apk
Shell/Bash
0 vote316 views2 answers
Permission denied while running startup.sh in linux
Shell/Bash
0 vote338 views2 answers
How to install gdal on pyhon 3.9
Shell/Bash
0 vote326 views1 answer
Ssh find function
Shell/Bash
174 votes575 views6 answers
Install nodemon as dev dependency
Shell/Bash
0 vote303 views1 answer
Install couchdb ubuntu 18.04
Shell/Bash