EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

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.

 

 


See also:

Specifying input parameters

Procedure Editor

UDF Editor