Export (0) Print
Expand All
8 out of 17 rated this helpful - Rate this topic

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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.