What are the various ways in which a stored procedure can be executed?

A stored  procedure can be invoked or executed using the following syntax :

1. EXEC < Procedure Name>
2. EXECUTE <Procedure Name>
3. <Procedure Name>

A stored procedure with the name 'USP_SAMP' can be executed using one of the following queries:

• EXEC USP_SAMP
• EXECUTE USP_SAMP
• USP_SAMP