whta are the stored procedure and why they are needed??
- 2 Answers
- 4654 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can I see what assemblies are installed in the global assembly cache?
Explain how do you initiate a string without escaping each backslash?
Define querystring collection?
Define session object?
What are the asp objects?
Define common language specification (cls)?
i learnt .net and would like to know if there is any institute in hyderabad that gives real time knowledge.i worked on testing and planning to move on to .net putting same amount of experience in .net.kindly suggest me the institute and other details.
Explain what are the methods in session object in asp?
What is the difference between razor and aspx view engine?
How do asp pages work?
Explain the post & get method or explain the difference between them in asp?
What are server-side includes?
Who invented asp?
Explain the difference between post & get method in asp?
What are the properties of session object?
