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

Question

Joginder Banger · Answer

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.

rgowthamraj ramajayam · Answer

who i use multiple qurey in single store procedure sir!!!!ANy Guide With Ex SImple

Joginder Banger · Answer

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

rgowthamraj ramajayam · Answer

thank You so much sir

Joginder Banger · Answer

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.