Free Resources from FMS

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.

 

Free Catalog

 

Interface for executing Stored Procedures in the SQL Query Analyzer

Provided by:  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.

  1. Use this interface to enter the appropriate parameters for the stored procedure.

  2. 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.

Click here to view the sample SQL Query Analyzer window

Click here to view the sample query

Return to the tips page