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 vote386 views3 answers
Git log for specific file
Shell/Bash
1 vote356 views4 answers
Install ssh ubuntu 20.04
Shell/Bash
2 votes342 views1 answer
Could not install packages due to an oserror
Shell/Bash
10 votes344 views4 answers
Copy ssh key mac
Shell/Bash
0 vote313 views1 answer
Connect to database for postgresql
Shell/Bash
7 votes367 views2 answers
Selenium install
Shell/Bash
1 vote376 views1 answer
The windows subsystem for linux component is not enabled
Shell/Bash
2 votes326 views2 answers
Install solana linux
Shell/Bash
11 votes333 views2 answers
Install pandas conda
Shell/Bash
0 vote325 views1 answer
Sed insert multiple lines after match
Shell/Bash