How to create a store procedure in sql server 2008.

When i was heard that store procedure is so secure to manage database. Many of freshers are not able to know about the basic of store procedure. So i decided to  wrote a blog on it.

What is store Procedure?

A store procedure is the group of the all sql statements which create to fetch data or manage data. We use it to make database fetching faster. 

Sql Syntax for Store procedure

---------------------------------------------------------------------------------

Create procedure procdure_name(@parametername datatype,@parametername1 datatype,@parametername2 datatype,)asbeginsql commandend

------------------------------------------------------------------------------------------------------------------------

Example of Store Procedure( for insert data)

create procedure [dbo].[caste_codes]
(
@castec bigint,
@cas_name varchar(50)
)
as
begin
insert into caste_pickup (Caste_code,Caste_Name) values(@castec,@cas_name)
end
GO

_____________________________________________

I hope you all enjoy the blog. Next will come soon.