How can I create a text file from SQL?

[cmdematos]

I want to create a text file from SQL - something like this..

DECLARE @A_FLD AS CHAR(5), @B_FLD AS CHAR(7)

SET @A_FLD = 'HI'
SET @B_FLD = 'MOM'

EXEC xp_<?????> FILENAME, @A + @B + '!'

The result must be...

'HI...MOM....!' in the text file.

Is there a simple way short of building an active-x control for this need?

 

[poulnielsen]

How about a good old DOS echo:

EXEC master..xp_cmdshell echo @a >log.txt,no_output
EXEC master..xp_cmdshell echo @b >>log.txt,no_output

>> = append
> = rewrite

 

[tlbroadbent]

DECLARE @A_FLD AS CHAR(5), @B_FLD AS CHAR(7)
DECLARE @CMD VARCHAR(60)

SET @A_FLD = 'HI'
SET @B_FLD = 'MOM'
SET @CMD='Echo ' + @A_FLD + @B_FLD + '! > C:\temp\testing.txt'
EXEC xp_cmdshell @CMD Terry Broadbent
Please review faq183-874.

&quot;The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge.&quot; - Daniel J Boorstin