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 vote143 views3 answers
Remove docker ubuntu
Shell/Bash
0 vote128 views1 answer
Get last element in an array bash
Shell/Bash
2 votes138 views3 answers
How to rename many files at once linux
Shell/Bash
4 votes131 views2 answers
Bash how to log in to remote server
Shell/Bash
28 votes129 views1 answer
Install gz file
Shell/Bash
0 vote138 views1 answer
Fork() system call in linux
Shell/Bash
4 votes145 views5 answers
Split string in shell script
Shell/Bash
0 vote138 views1 answer
TkPDFViewer install
Shell/Bash
10 votes132 views3 answers
Force delete pod kubernetes
Shell/Bash
0 vote132 views4 answers
Storage/logs/laravel.log" could not be opened: failed to open stream: Permission denied
Shell/Bash