https://blogmepost.com/images/blogmepost.webp

Question

How to execute a stored procedure?

Answer 1

There are two way to execute a stored procedure.

From the SQL prompt, write EXECUTE or EXEC followed by procedure_name.

1. EXECUTE or [EXEC] procedure_name;  

Simply use the procedure name

1. procedure_name;