ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Scripts  >>  ASP
 
 


 

 
 PHP interview questions  PHP Interview Questions
 ASP interview questions  ASP Interview Questions
 CGI Perl interview questions  CGI Perl Interview Questions
 JavaScript interview questions  JavaScript Interview Questions
 VB Script interview questions  VB Script Interview Questions
 JSP interview questions  JSP Interview Questions
 Shell Script interview questions  Shell Script Interview Questions
 Python interview questions  Python Interview Questions
 Tcl interview questions  Tcl Interview Questions
 Awk interview questions  Awk Interview Questions
 AJAX interview questions  AJAX Interview Questions
 Ruby on Rails interview questions  Ruby on Rails Interview Questions
 Scripts AllOther interview questions  Scripts AllOther Interview Questions
Question 
whta are the stored procedure and why they are needed??
 Question Submitted By :: Ashamalik
I also faced this Question!!     Rank Answer Posted By  
 
  Re: whta are the stored procedure and why they are needed??
Answer
# 1		 
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 ?    0 Yes 1 No
Ponprabhu
 
  Re: whta are the stored procedure and why they are needed??
Answer
# 2		 
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 ?    1 Yes 0 No
Sudhir Singh
 
 
 

 
 
 
Other ASP Interview Questions
 
  Question Asked @ Answers
 
What is the command to display characters to the HTML page?  1
What is a Form collection?  1
What is a Virtual Directory?  1
What are ARRAYS?  3
Why can't use DAO instead of ADO?  1
what are ASP Objects?  1
What's the Difference between DSN and DSN Less connection?  2
What is difference between Physical path and Virtual path? Explanin with example.  1
What is Server Object? NIIT2
What is the difference between client-side script and server-side script?  1
Tell something about Active Server Pages? Microsoft4
How will you set the values for cookies?  1
What is Request Object?  2
What are the properties used to control the expiration of the page?  1
How to determine if a visitor has cookies support enabled in his/her browser?  1
What is a FileSystemObject object?  1
What is difference between Server.transfer and Response.redirect ?  4
What is the difference between ASP and HTML?  2
What is Extranet? FutureSoft3
What does Server.MapPath do?  2
 
For more ASP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com