Online Documentation for SQL Manager for SQL server

Executing procedure/function


Procedure Editor / UDF Editor provide an ability to execute procedures and user-defined functions. Click the btnExecuteQuery Execute item of the Navigation bar or use the corresponding toolbar button to execute the procedure/UDF.

 

If the procedure/UDF has input parameters, SQL Manager allows you to specify the values for these parameters in the Input Parameters dialog which appears just before execution.

 

The result of the successfully executed procedure/UDF, as well as the error message in case of execution failure, appears in the message panel at the bottom of the Procedure Editor / UDF Editor window.

 

Procedure Editor - Executing procedure

 

 

Note: If any unsaved changes are applied to the stored procedure/UDF being currently edited, the execution of the procedure/UDF is impossible unless changes are saved through the Compile item of the Navigation bar.