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 vote273 views1 answer
Display/search for a commit hash name in a git log
Shell/Bash
0 vote310 views1 answer
Jbl bt wireless headphones not working in fedora linux
Shell/Bash
0 vote286 views1 answer
How to reove bash varible from memory
Shell/Bash
0 vote288 views1 answer
Pushing code with another github account
Shell/Bash
0 vote277 views2 answers
Mailgun "permanent failure for one or more recipients" blocked
Shell/Bash
1 vote267 views1 answer
React native Could not find "Podfile.lock" at
Shell/Bash
0 vote299 views1 answer
Anydesk linux install download
Shell/Bash
10 votes275 views3 answers
Ubuntu certbot nginx
Shell/Bash
1 vote291 views2 answers
-bash: /bin/rm: Argument list too long inodes
Shell/Bash
0 vote321 views1 answer
Npm legacy-peer-deps
Shell/Bash