Stored procedure output to a file


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Stored procedure output to a file

  1. #1
    Dan Collins Guest

    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?
    Thanks,
    Dan Collins

  2. #2
    Paul Mc Guest

    Re: Stored procedure output to a file


    G'day Dan.

    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...

    Cheeers,
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center