declare @str varchar(100)
select @str = 'declare @i int'
print @str
select @str = 'ECHO ' + @str + ' >>C:\file1.txt'
EXEC xp_cmdshell @str, no_output

declare @str varchar(100)
select @str = 'create table #test
(ind int primary key not null,
 name varchar(50)
 )'
print @str
select @str = 'ECHO ' + @str + ' >>C:\file2.txt'
EXEC xp_cmdshell @str, no_output

declare @str varchar(8000)
select @str = 'create table #test 
(ind int primary key not null,
 name varchar(50)
 )'
PRINT @str
select @str = 'ECHO ' + REPLACE(REPLACE(@str,CHAR(10),' '),CHAR(13),' ') + ' >>D:\file2.txt'
EXEC xp_cmdshell @str, no_output