Interface for Executing Stored Procedures in the SQL Query Analyzer

Provided by the FMS Development Team

The SQL Query Analyzer has a user interface that will assist you with the execution of a stored procedure that contains input and/or output parameters. This interface is much easier to use than typing out the entire EXEC sp_name statement.

1. Open SQL Query Analyzer to the respective database.
2. Click [F8] or click the Object Browser button on the menu bar.
3. In the tree view, select the respective database folder.
4. In the respective database folder, select the "Stored Procedures" folder.
5. Select the stored procedure in the list. In this example, the stored procedure is named ‘dbo.stpGetPersonNameByID’.
6. Click the right-mouse button to open the pop-up menu and select "Open". The following dialog box appears.

   

7. Use this interface to enter the appropriate parameters for the stored procedure.
8. Click the "Execute" button.

The Query window opens and the top portion of the query window displays the lines of code that were executed. The bottom portion of the query window displays the results of the executed stored procedure. Furthermore, the input and output values are present for you to modify in the event you want to run the stored procedure with different values.

We've provided an image of a SQL Query Analyzer window. Also, you can view the Sample Query.