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 vote193 views1 answer
Cd n directories back
Shell/Bash
33 votes150 views2 answers
Install node on linux
Shell/Bash
0 vote198 views1 answer
Nearest location using php
Shell/Bash
0 vote254 views1 answer
App to see git branches in ubuntu
Shell/Bash
2 votes195 views1 answer
Vim replace character with new line
Shell/Bash
1 vote194 views1 answer
How to trim log file linux
Shell/Bash
0 vote189 views2 answers
Winrar limit procasing
Shell/Bash
0 vote299 views2 answers
Git diff with remote branch
Shell/Bash
0 vote178 views1 answer
Not able to start conda navigator ubuntu 18.04
Shell/Bash
0 vote185 views1 answer
Install MySQL FreeBSD
Shell/Bash