You can run a stored procedure without
invoking a launch configuration.
Running a stored procedure allows you to run and obtain SQL results
from the database.
PrerequisitesÂ
Before you can run a stored procedure, save or deploy it to a database.
If procedural
objects are modified in an editor, a dialog displays to prompt you to save to
the database before running.
-
In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.
| Database |
Steps |
|---|
| From an ASE connection profile |
- Expand the Databases folder.
- Expand the tree for a database
and then the tree for the appropriate schema owner.
|
| From a SQL Anywhere or Sybase IQ connection profile |
- Expand the
tree for a database.
- Expand the
Schemas folder and then the tree for the appropriate schema owner.
|
- Expand the
Stored Procedures folder, right-click the
stored procedure, and choose
Run.
- (Optional) If the stored procedure includes parameters, modify the parameter values.
- Click
OK to run the procedure.
SQL Results view displays the status of the run
instance, the execution details, and returns result sets and server messages,
if any.