Different Ways To Execute Stored Procedure

Question

What are different ways to execute stored procedure?

Satyapriya Nayak · Answer

There are two different ways to execute a stored procedure. The first and most common approach is for an application or user to call the procedure. The second approach is to set the procedure to run automatically when an instance of SQL Server starts. When a procedure is called by an application or user the Transact-SQL EXECUTE or EXEC keyword is explicitly stated in the call. Alternatively the procedure can be called and executed without the keyword if the procedure is the first statement in the Transact-SQL batch. http://msdn.microsoft.com/en-us/library/ms189915.aspx