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

1 vote130 views1 answer
Number fo files prestn in gcs bucket command
Shell/Bash
0 vote112 views1 answer
Raspberrypi install xserver
Shell/Bash
0 vote120 views3 answers
Ubuntu Not Found The requested URL was not found on this server. Apache/2.4.41 (Ubuntu) Server at localhost Port 80
Shell/Bash
2 votes233 views2 answers
React native image picker
Shell/Bash
0 vote118 views1 answer
My numpad stopped working in ubuntu
Shell/Bash
19 votes144 views6 answers
Install apache2 ubuntu
Shell/Bash
0 vote119 views2 answers
Programming scares me
Shell/Bash
0 vote122 views1 answer
How to uninstall pycharm professional in ubuntu 16.04
Shell/Bash
2 votes139 views2 answers
How to use dotenv in javascript
Shell/Bash
0 vote128 views1 answer
Não é possível excluir uma partição protegida sem o parâmetro de proteção forçada definido.
Shell/Bash