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

What is work flow gen? how can it will work with .Net?

0 Answers   TCS,


I have developed a web application in asp.net 2.0 with Access as back end i am trying to gereate report/export data in excel. After hosting the site i am not getting any error or such exported excel file. but using the source code from my system it works fine. Could any one tell me why it is happening and what is its solution.

2 Answers  


What is boxing and unboxing ?

7 Answers   Accenture, Infosys, MedTek,


What is manifest in .net framework?

0 Answers  


What is difference between abstract class and an interface?

0 Answers  


How is my content secured from unauthorized access?

0 Answers  


Explain significance of routing? : asp.net mvc

0 Answers  


What is an application domain ?

2 Answers   Microsoft,


What is the first name space in .netF/W heirarchy

3 Answers   Wipro,


can we place the same DLL in debug folder two times? (without using strong name )

9 Answers   TCS,


What is a 1x1 pixel?

0 Answers  


What is session state server?

0 Answers  


Categories