whta are the stored procedure and why they are needed??
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 the life cycle of asp page.
Name the asp objects?
How do I open aspx files?
Define a form collection?
can any one tell me about dot net framework not basic detail
Define application object in asp?
What is asp format?
When was asp released?
What are asp controls?
What happens to asp pages?
what is the default .net provider
Define microsoft intermediate language (msil)?
Define a variable in asp?
How do I create an aspx page?
In case of we are not saving the information as cookies. how server detects the same user?