Executing Stored Procedures in SQL Query Analyzer

SQL Query Analyzer Help

SQL Query Analyzer Help

Executing Stored Procedures in SQL Query Analyzer

SQL Query Analyzer provides multiple ways to execute stored procedures.

  • You can enter the statement to execute the stored procedure directly in the Editor pane and press F5. If the statement that executes the procedure is the first in the batch, you can omit the EXECUTE (or EXEC) statement; otherwise, EXECUTE is required.

  • You can right-click a stored procedure in Object Browser or Object Search dialog box and select Open to invoke the Execute Procedure dialog box. This dialog box lists any parameters and provides a text box where you specify parameter values.