whta are the stored procedure and why they are needed??
- 2 Answers
- 4668 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 we done appllication deployment
I am not doing well in my oracle class and desparetly need some help. My main problem is the join chapter. I am very frustrated right now because I got my first zero in my in school lastweek. I excell in every other subject except oracle. I really would like to learn the program, but it looks dim for me right now and it is too late to drop the class without getting 'F'. Can someone pleae help me. with this one because I only have a few days before my assignment is due. If you leave your email I will get intouch with you immediately. Thanks
what is the default .net provider
What are the scripting objects in asp?
where should i get free version of Test Director to download
Define querystring collection in asp?
Is asp a language?
What is difference between asp and aspx?
Define a form collection?
What is the microsoft intermediate language (msil)?
Why do we use asp?
Explain the difference between a namespace and an assembly name?
What is Response object? How is it related to ASP's Response object?
Define global.asa file?
What is n-tier system?
