--这样也不行?
exec master..xp_cmdshell 'bcp "use isalog select top 1 logtime,originalclientip from firewalllog where action=''Denied'' " queryout c:\ipinfo.txt -c -S. -Usa -Psa'
exec master..xp_cmdshell 'bcp "use isalog select top 1 logtime,originalclientip from firewalllog where action=''Denied'' " queryout c:\ipinfo.txt -c -S. -Usa -Psa'
不行,要报列名Denied无效我记得上次申明了一个变量,怎么搞的就弄好了,今天又导,怎么都不行,昏