以下测试通过:
declare @i varchar(5),
@FileName varchar(100),
@execcmd varchar(8000)
set @i = '1'
set @FileName = 'C:\test.txt'
set @execcmd='bcp "SELECT '''+@i+''' as Comp,* FROM tempdb.dbo.##test_tel" queryout '+@FileName+' -c -S"192.168.1.1" -U"sa" -P"my_pwd"'
exec master..xp_cmdshell @execcmd