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

2 votes190 views1 answer
Install Material ui on react app
Shell/Bash
16 votes183 views3 answers
Download github desktop ubuntu
Shell/Bash
1 vote231 views2 answers
Remove directory not empty windows
Shell/Bash
0 vote175 views2 answers
Read-json-data-response-using-php
Shell/Bash
0 vote175 views2 answers
Set permissions linux for drive chmod group
Shell/Bash
0 vote177 views1 answer
Linux log serial to binary file
Shell/Bash
0 vote202 views1 answer
Activar htaccess en apache
Shell/Bash
0 vote188 views1 answer
Kernel version link
Shell/Bash
0 vote187 views1 answer
Mongoimport source list ubuntu 20.04
Shell/Bash
0 vote195 views1 answer
Debian kernel ppa
Shell/Bash