What is stored Procedure?
Stored procedure is a precompiled object stored in Databsae.
creating SP................
================================================================
create procedure p1
as
Begin
select * from table1
end
=====================================================================
execute SP
==========
EXEC p1
==========