Execute a Stored Procedure

How to execute a Stored Procedure?


There are two ways to execute a procedure.

1) From the SQL prompt.

EXECUTE [or EXEC] procedure_name;


2) Within another procedure – simply use the procedure name.

procedure_name;