How to execute below stored procedure?

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

 Posted by vishalneeraj-24503 on 11/29/2013 | Category: Sql Server Interview questions | Views: 872 | Points: 40
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.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response