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

can we pass values from one page to another page without redirecting to that page?

6 Answers   Google, Patni, Syntel, Wipro,


Explain how cookies work. Give an example of cookie abuse.

0 Answers  


What is difference between cookies and cache?

0 Answers  


Define a multilingual website?

0 Answers  


How can we create a website?

0 Answers  


What tags do you need to add within the asp:datagrid tags to bind columns manually? How?

0 Answers  


Explain what are webservices?

0 Answers  


Where are session variables stored?

0 Answers  


Describe state management in asp.net?

0 Answers  


Types of values mode can hold session state in web.config ?

1 Answers   Accenture, Parrot Systems,


wt is repeater control and wt is datalist control and wt defferences these two? i want some code in datalist?

1 Answers  


Explain server control extensibility with reference to asp.net 2.0 ?

0 Answers  


Categories