Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


whta are the stored procedure and why they are needed??

Answers were Sorted based on User's Feedback



whta are the stored procedure and why they are needed??..

Answer / sudhir singh

Store Procedure is the collection of SQL Statement which is
accept the input parmeter and output parameter.
Kinds of store procedure.
1. User Define Store Procedure
2. Systemp Store Procedure : Start with Pre-fix SP.
3. Temperory Store Procedure: it has two type private store
Procedure and Global Store Procedure. Private store
procedure create by singl(#) and Global store procedure
create by double(##).
4. External store procedure: start with Pre-Fix XP.

Store Procedure use for better performation of programm.
because storeprocedure is pre-compile query and ADO.NET less
string send to server.

Is This Answer Correct ?    5 Yes 2 No

whta are the stored procedure and why they are needed??..

Answer / ponprabhu

Srored Procedure is the Concept.Lot of Related sql Queries
are Stored inside the Server Database.The Queries are
executed by the user Explicitly.The Stored Procedure is
used to make the sequence Transactions

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More ASP Interview Questions

Hii My Question is How the Down Payment will clear in APP? Can any one help me

0 Answers  


What is aspx in url?

0 Answers  


What are the collections of Session Object?

2 Answers  


what are the two main compononet in remoting

0 Answers   DCI,


What is classic asp application?

0 Answers  


How do I open aspx files on android?

0 Answers  


What is the difference between asp and html? Or why asp is better than html?

0 Answers  


What is Server Object?

2 Answers   NIIT,


Explain the difference between querystring collection and form collection?

0 Answers  


What is an asp program?

0 Answers  


1)Declare array with five elements a[]={8,4,6,2,1,10} Print minimum and maximum no from array.

1 Answers   Infosys, Syntel,


How does non-deterministic garbage collection affect my code?

0 Answers  


Categories