whta are the stored procedure and why they are needed??
- 2 Answers
- 4618 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 |
how to configure asp.net website in vs2008. and the projects devoloped in 2005 can be run in 2008
Define an application domain?
Explain the difference between client-side script and server-side script?
What type of code is found in a code-behind class?
define the functionality of web server in context to Active server page.
Give the comment tags for the following?
What are server-side includes?
How You Can use Dropdownlist with in Data Grid .DropDownlist having data from Database?
what is WCF?
Should user input data validation occur server-side or client-side?
no.of pages comes before protected void ?
What are the features of asp?
ASP 
