Interested to Buy Any Domain ? << Click Here >> for more details...
whta are the stored procedure and why they are needed??
- 2 Answers
- 5852 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
Define server object?
How can you disable the browser to view the code?
IN THREE TIER AMONG THREE LAYERS WHICH ONE IS INDEPENDENT LAYER AND HOW?
how to implemet online examination in asp.net
How do I convert an aspx file to pdf?
What is the difference between cshtml and aspx?
What data types does the rangevalidator control support?
How to add? tree view control in datagrid in asp.net using c#?
What is the difference between sap r/2 and r/3
Resource Files: How to use the resource files, how to know which language to use?
What is querystring collection in asp?
What are private assemblies and shared assemblies?
What is the maximum size of an array in asp?
What is an asp model?
How do you open an asp file?
