What mean store procedure?rules of it : and basic guide?

i create a store procedure as per your need.


create proc testing
(
@sample varchar(max)=null // assign the null value is optional.



)
as
declare @tempid int
begin
select @tempid=columnname from tablename1 where columnname=@sample

another table define below

select * from tablename2 where columnname=@tempid
end


i hope you understand. 

if some help my answer accept the answer for understanding another.

Hi RGOWTHAMRAJ
Store Procedure is a main concept in programming line. we can work without store procedure but some problem will be occur. Sql Injection it is dangerous for our development link. for more info about the Sql injection hit this link
http://www.programmerinterview.com/index.php/database-sql/sql-injection-example/
. A store procedure is protect our sql query.
for example I search the records behalf on customer Mobile Number. I need a textbox and one button . I written a simple query
sqlCommmand com= new SqlCommand("select * from tablebame where mobileNO='"+textbox1.text'",connection string");
//another do stuff here

it's work fine. if we enter in the textbox --select * from table. query automatic comment and all data return.

This type of problem store procedure protect.
no need compile every time. A lot of advantage if we used the Store procedure.