Stored procedure output to a file
How do I direct output from a stored procedure to a file? I am using the Print
statement that prints output to the Query Analyzer screen. I do I direct
Print statements to a test file?
Re: Stored procedure output to a file
The Print statement in TSQL is not what it sounds like - basically it similar
to Debug.Print in VB except that it is not left out at compile time...
As for directing output to a file, that depends on the circumstances:
A) What is the situation - are you running the SP from the query analyser
or via ADO from a client app etc...
B) Where do you want the file - ie do you want the server to output it to
a file one the server, or the client to control the writing of the file?
C) What format do you want? ie Text, HTML, XML?
If you detail the situation further I am sure we could help you out...
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL