Test BCP export and query a text file

Xp_mongoshell 'bcp "select * From sysobjects" queryout D:/w1.txt-T "|"-S 127.0.0.1-U sa-p-C'

If the-C parameter is not specified, a confirmation message is displayed for the format of each row.

Queryout and out. For query, it must be queryout. BCP has strict requirements and must be specified as queryout.

The BCP command is located in the directory program files/Microsoft SQL Server/80/tools.

 

Try again today

Xp_cmdshell 'bcp "select. *, 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. khdh = B. dwbh join balance .. jb_zg C on. pzsby = C. zgbh join balance .. jb_zg D on. mzsby = D. zgbh join balance .. jb_wz h on. wzbh = H. wzbh where khdh = '24' and. wzbh = ''07 ''" queryout D:/w1.txt-T "|"-S 127.0.0.1-U sa-P dotbit20042626-C'