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  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ASP.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
About writting a query and SP which is better ?
 Question Submitted By :: Sweety
I also faced this Question!!     Rank Answer Posted By  
 
  Re: About writting a query and SP which is better ?
Answer
# 1
sp is the better one...
Its compile and inside that we can write any number of 
Query Statement , finally for the whole thing it will 
create only one object as a reference .

But in Query Statement Each query be an Objects ...

Got it!!!!!
 
Is This Answer Correct ?    3 Yes 0 No
Martin
 
  Re: About writting a query and SP which is better ?
Answer
# 2
Stored Procedure is always super'b effective bcz it is pre-
compiled statements so it's great !!!!!!!!!!!!!!!!!
 
Is This Answer Correct ?    0 Yes 1 No
Vickys & Sugan
 
 
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
How can we prevent an aspx page get refreshed when any information fetch from the database ? Minecode2
Explain the differences between Server-side and Client-side code? Visual-Soft6
Breifly explain about stack and heap memory Managemet?  1
how can i call output parameters from ado.net TCS2
What is the use of Administration tool in Asp.net 2.0?  2
Is There any Third party tools are using in .Net Technologies? Can u Explain? HCL2
how many databases and tables are uses in one project?  2
How do you do exception management? Accenture1
What data types do the RangeValidator control support?  2
Difference between ADO.Net 1.1 and ADO.Net 2.0 ? Value-Labs1
how can i inharit multiple classes?  1
You create an ASP.NET application for a hotel. The application contains a page that displays current weather conditions for the city in which the hotel is located. The application calls an XML Web service every 10 minutes to update the current weather conditions. A new page is then displayed for subsequent requests. You want the same page to be cached and retrieved from the cache during the time between calls to the XML Web service. You decide to use a Page directive to accomplish this goal. Which Page directive should you use? A . <%@ Cache Seconds="600 '' VaryByParam="Page" %> B . <%@ OutputCache Time="600" %> C . <%@ OutputCache Duration="600" VaryByParam="None" %> D . <%@ OutputCache Duration="600" %> Syntax-Softtech2
Describe the difference between inline and code behind - which is best in a loosely coupled solution Tightly coupled - INLINE  1
difference between caching objects in session objects?  2
When would you set this property to false?  1
Explain what a diffgram is, and a good use for one? FT1
i want to develope a page for online test using asp.net with c#.net. so, how to insert the questions in the database sqlserver2000 and how to pick the questions randomly when user login for test. plz send the code for this.... TCS3
how to convert from sql2000 numeric to int in asp.net with sqlparameter?  1
Way of updating a table other than stored procedure and hard coded query?  2
How cross page posting is done in Asp.net 2.0?  3
 
For more ASP.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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