whta are the stored procedure and why they are needed??
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 |
What is the common language specification (cls)?
Name the methods in application object?
What are the properties used to control the expiration of the page?
by puting attendance to students if he absent tat should intimate to his fathers mobile automatically anybody having code send to me
How add insert options in datagrid control in footer row.
What is the difference between jsp and asp?
Tell me about Dictionary Object?
What data types does the rangevalidator control support?
How can you change the primary scripting language for a page?
How to make page break in Crystal Report..?
what is mean of ASP?
explain with example redaing contents and writing contents from a file using APS object stream.