Execute the stored procedure

Executation Store Procedure:

(1)

you can just type the procedure name and press F5, or use EXEC or EXECUTE keywords followed by the procedure name as shown below.

1. EXEC spGetEmployees
2. Execute spGetEmployees

 

(2)

  You can also right click on the procedure name, in object explorer in SQL Server Management Studio and select EXECUTE STORED PROCEDURE.