急求大虾:如何将SQLSERVER中的sql语句查询结果导出成txt文件???
dhb77 2004-07-27 10:55:04 各位:我知道EXEC master..xp_cmdshell 'bcp "Select * from scan7db..VulnsFound" queryout D:\DT.txt -c -S dhb -U sa -P '
的用法,执行也正确。可是为什么上面的命令在查询分析器中转行了,就不能执行了呢?
我的sql很长,不像上面的Select * from scan7db..VulnsFound那么简短,我在查询分析器里执行怎么也不生成txt文件。sql是没有错的,我该怎么办呢?
附:我要导出的查询结果:
select ScannerType=2, a.vulnID as ID, a.vulnName as vulnName, Port='',
(case a.Severity when 1 then 4 when 2 then 3 when 3 then 2 end) as VulnValue,
a.Severity as Severity, a.shortDesc, b.statusTime as UpdateTime,
c.ipAddressStr as AssetIP, b.jobID
from Vulns a
inner join VulnsFound b on a.vulnID = b.vulnID
inner join Hosts c on b.hostID=c.hostID
UNION ALL
select ScannerType=2, a.ServiceID as ID,a.serviceName as vulnName,
(case a.ports when 0 then NULL else a.ports end) as Port,
VulnValue=1, Severity=1, a.shortDesc, UpdateTime=Getdate(),
c.ipAddressStr as AssetIP , b.jobID
from Services a
inner join ServicesFound b on a.ServiceID = b.ServiceID
inner join Hosts c on b.hostID=c.hostID