What is stored Procedure

Stored Procedure:-Stored procedure is a precompiled object stored in Database.

Creating Stored Procedure:-

create procedure sp1

as

Begin

select * from table1

end

Execute Stored Procedure:-

EXEC sp1