Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
SQL ResultSet to a txt fileHi, Using T-SQL is it posible to write the resultset of a select statement to a text file?. If possible please give me the details. Thanks in advance. Regards, Sha
Post Follow-up to this message
Re: SQL ResultSet to a txt fileYou have to open up a cmdshell for this to save the results to a file, something like: xp_cmdshell 'OSQL -E -Q"Select * FROM SomeTable" -O"C:\myoutputfile.txt"' HTH, Jens Suessmeyer.
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
