SQL Reference - EXECUTE

Example

CREATE PROCEDURE MyProcedure
AS
SELECT 'Hello, World!'
GO

EXECUTE MyProcedure
GO

Output

'Hello, World!'

Explanation

The EXECUTE statement is used to run a stored procedure in SQL Server. In the provided example, a procedure named MyProcedure is created. This procedure, when called, simply returns the string ‘Hello, World!’. The EXECUTE statement is then used to run MyProcedure, resulting in the output ‘Hello, World!’.

Example

CREATE PROCEDURE simpleProcedure
AS
BEGIN
   dbms_output.put_line ('This is an example of a simple stored procedure');
END;
/

EXECUTE simpleProcedure;

Output

This is an example of a simple stored procedure

Explanation

This example illustrates the use of EXECUTE in SQL. A basic stored procedure named simpleProcedure is defined using the CREATE PROCEDURE statement. The procedure using the built-in dbms_output.put_line to display a text message. The EXECUTE statement is then used to run simpleProcedure, producing the output message: ‘This is an example of a simple stored procedure’.