Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


About writting a query and SP which is better ?

Answers were Sorted based on User's Feedback



About writting a query and SP which is better ?..

Answer / martin

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 ?    8 Yes 0 No

About writting a query and SP which is better ?..

Answer / vickys & sugan

Stored Procedure is always super'b effective bcz it is pre-
compiled statements so it's great !!!!!!!!!!!!!!!!!

Is This Answer Correct ?    2 Yes 2 No

About writting a query and SP which is better ?..

Answer / surendra

Stored procedures........
group of queries is nothing but sp..in sp we can use
functions etc

Is This Answer Correct ?    0 Yes 0 No

About writting a query and SP which is better ?..

Answer / amit patel

Stored procedures is better because it is fast in excution
and also it will save from sqlInjection

Is This Answer Correct ?    0 Yes 0 No

About writting a query and SP which is better ?..

Answer / anand

SP is better than the query bcoz SP is pre compiled unit so
it reduce burden on the server

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

Which of the following hosts Can't be used to create .net Application? a) IIS b) Internet Explorer c) ASP.Net d) Windows Shell Which one is correct?

1 Answers   CTS, TCS,


Difference between .NET components and COM components?

2 Answers   Microsoft,


What are the components of ado.net?

0 Answers  


What are the disadvantages of using session?

0 Answers  


What is the use of execute non query in asp.net?

0 Answers  


Types of objects in ASP ?

2 Answers   Microsoft,


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" %>

2 Answers   Syntax Softtech,


About duration in caching technique ?

4 Answers   Accenture,


what is the use of asp.net

3 Answers   ABC,


What is versioning in .NET?

1 Answers   Syntax Softtech, Wipro,


Can asp.net work on an nt server?

0 Answers  


How do you change the session time-out value?

0 Answers   TryTechnicals Pvt Ltd,


Categories