whta are the stored procedure and why they are needed??
- 2 Answers
- 4639 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
Explain life cycle of asp page.
___________ and ____________ properity to be used to create localized version of a form
How do I open an asp file on a mac?
what is the need of a sealed class when we are having a structure
Suppose someone gives a VB dll file (component). How to use that in an ASP file?
Define global.asa file?
difference between partial and public ?
Define session object?
How can you disable the browser to view the code?
What does active server pages look like?
What is querystring collection in asp?
Can .net framework components be used from a com program?
What do I have to do to make my code work with the security system?
How will u make automatic login program in asp as u see in yahoo messanger? When any body login to their system they no need to fill userid and password. It automatically fills the userid and password.
What is a request body?
