How to execute below stored procedure?

create procedure load_employee_details
as
Go
begin
select * from employee_master where status = 'AA';
end

Answer:

With the help of EXEC in-built SQL Server function we can Execute any user defined Stored Procedures as well as system Stored Procedures.

Syntax is:-

Exec <procedure_name>(parameter_name1,parameter_name2,.....);

For above SP,we will write:-

Exec load_employee_details;

Press F5 to execute SP.