EXEC master..xp_cmdshell
'bcp "SELECT A.YHZH, B.YHMC, C.ZJE, B.DAH ,B.YHMC FROM jd_Gas.dbo.T_BCXXB D INNER JOIN jd_Gas.dbo.T_YHDAB B ON D.DBBH=B.DBBH INNER JOIN jd_Gas.dbo.T_YHDKYHZL A ON A.DAH=B.DAH INNER JOIN jd_Gas.dbo.T_CBJLB C ON B.DAH = C.DAH AND A.DAH = C.DAH where 1=1 AND c.cbyf=@VCBYF and B.SFFS = ''"银行代扣"''"
queryout c:\DT.txt -c -t"|" -U"sa" -P"sa"'在c.cbyf=@VCBYF 这边要怎么点啊,我怎么都是错的呀谁帮帮忙呀。。
'bcp "SELECT A.YHZH, B.YHMC, C.ZJE, B.DAH ,B.YHMC FROM jd_Gas.dbo.T_BCXXB D INNER JOIN jd_Gas.dbo.T_YHDAB B ON D.DBBH=B.DBBH INNER JOIN jd_Gas.dbo.T_YHDKYHZL A ON A.DAH=B.DAH INNER JOIN jd_Gas.dbo.T_CBJLB C ON B.DAH = C.DAH AND A.DAH = C.DAH where 1=1 AND c.cbyf=@VCBYF and B.SFFS = ''"银行代扣"''"
queryout c:\DT.txt -c -t"|" -U"sa" -P"sa"'在c.cbyf=@VCBYF 这边要怎么点啊,我怎么都是错的呀谁帮帮忙呀。。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货