Running a stored procedure allows you to run and obtain SQL results from the database. You must first save or deploy the stored procedure to the database. If procedural objects are modified in SQL Editor, a dialog displays to prompt you to save to the database before running. The following method of running a stored procedure provides a shortcut to invoking a launch configuration.
To run a stored procedure:
In Database Explorer, open the Procedures & Functions folder for your database.
Select the stored procedure you want to run and right-click it.
Select Run Procedure or Run Function. If the stored procedure or function includes parameters, the Configure Parameters dialog appears. You can alter parameter values from here.
Click OK to run the procedure or function.
SQL Results view displays the status of the run instance, the execution details, and returns result sets and server messages, if any.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com