Interested to Buy Any Domain ? << Click Here >> for more details...
whta are the stored procedure and why they are needed??
- 2 Answers
- 5619 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
1)Declare array with five elements a[]={8,4,6,2,1,10} Print minimum and maximum no from array.
How does VaryByCustom work?
Explain how is method overriding different from overloading?
What does asp mean in technology?
What is asp full form?
What are private assemblies and shared assemblies?
How long is a SessionID guaranteed to be unique? A. It is unique for the web server, whether it is restarted or not. B. Only until the web server is restarted. C. It is like a GUID in that it is for any web server at any time. D. Only until the session expires, then it can be reissued to another client. E. It is unique per client. A client cannot have two sessions with the same SessionID
How to include active x controls in asp code?
IN THREE TIER AMONG THREE LAYERS WHICH ONE IS INDEPENDENT LAYER AND HOW?
What are the ASP Scripting Objects?
6) Events in page life cycle?
where should i get free version of Test Director to download
ASP 
