Command Line execution of a Stored Procedure?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Command Line execution of a Stored Procedure?

  1. #1
    Kristin Piskulic Guest

    Command Line execution of a Stored Procedure?


    Is is possible to execute a Stored Procedure from the command line? If so,
    how? We are wanting to make a short cut on a users desktop to run a stored
    procedure.

    Thanks,
    Kristin

  2. #2
    Michael Levy Guest

    Re: Command Line execution of a Stored Procedure?

    You can use isql.exe for 6.5 or osql.exe for 7.0.

    osql -Sserver_name -E -ddatabase_name -Q"EXECUTE spname parm1, parm2"

    type osql /? at a command prompt for the complete list of options.

    -Mike

    --
    Michael Levy MCSD, MCDBA, MCT
    Consultant
    GA Sullivan
    michaell@gasullivan.com




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