Home > IT Answers > SQL Server > How to save the output from an SQL select statement to a spool file
Tomotsk
75 pts.
 How to save the output from an SQL select statement to a spool file
SELECT statement, Spool files, Spool to Flat, SQL, SQL statements, Start Structured Query Language, STRSQL
Please can someone tell me how I can save the output from an SQL select statement to a spool file. Thanks, Tom

Software/Hardware used:
ASKED: December 12, 2008  10:23 AM
UPDATED: June 19, 2011  3:03 PM
RELATED QUESTIONS
Answer Wiki:
Hi, If you're running your SQL statement from STRSQL - Press F13 (Services), select option 1 (Change session attributes), Change the "SELECT Output" parameter to option 2 = Printer. Regards, Martin Gilbert.
Last Wiki Answer Submitted:  December 12, 2008  10:53 am  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

excellent….cheers!!!

Ymym
 10 pts.