xp_cmdshell 'bcp "select * from sysobjects" queryout d:/w1.txt -t "|" -S 127.0.0.1 -U sa -P -c'
如果没有-c这个参数,将会提示是每一行的格式确认
queryout 以及out,如果是查询,一定要是queryout,BCP在此要求比较严格,必须要注明是queryout
BCP命令位于: program files/microsoft sql server/80/tools目录下
今天再次试验
xp_cmdshell 'bcp "select a.*,jz=mz-pz ,b.dwmc,c.zgxm as sby,d.zgxm as msby,h.wzmc from balance..zy_czjl a join balance..jb_dw b on a.khdh=b.dwbh join balance..jb_zg c on a.pzsby =c.zgbh join balance..jb_zg d on a.mzsby=d.zgbh join balance..jb_wz h on a.wzbh=h.wzbh where khdh=''24'' and a.wzbh=''07''" queryout d:/w1.txt -t "|" -S 127.0.0.1 -U sa -P dotbit20010426 -c'