Thursday, 6 June 2013

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

No comments:

Post a Comment

Receive All Free Updates Via Facebook.