All ,
Is it possible that i can get the result of executed select statement in a .txt file.
some thing like this
select * from mytablw to <some file name.txt>
Regards,
Ashish
You need to use BCP.
You either invoke it from a cmd window or use xp_cmdshell in SS.
Code Snippet
From cmd:
bcp "SELECT * FROM MyTable" queryout "c:\My Output File.txt" -c -Smyserver -Umylogin -Pmypswd
From SQL Server:
EXEC master..xp_cmdshell 'bcp "SELECT * FROM MyTable" queryout "c:\My Output File.txt" -c -Smyserver -Umylogin -Pmypswd'
Look up BCP in BOL for more options and parameters.
