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.


Additional Resources

 

 

Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.


View all FMS products for Microsoft Access All Our Microsoft Access Products

 

 

Free Product Catalog from FMS