Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Executing Stored Procedures in SQL Query Analyzer

Executing Stored Procedures in SQL Query Analyzer

SQL Server 2000

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.
© 2015 Microsoft