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

Explain Features in ASP.NET

0 Answers   Microsoft,


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....

3 Answers   Chaitanya, Crysalis, CTS, HCL, Sein Infotech, TCS,


What is a 404 redirect?

0 Answers  


The technical part was on ASP.Net only of web services.

1 Answers   Symphony,


Explain autherization levels in .net ?

2 Answers  






When is an object collected by the Garbage Collector? [Four options were given]

1 Answers   ABC,


What is the Difference between Web.config and global.asax? Can we write connection String code in global.asax?

10 Answers   Microsystems,


In a webservice, need to display 10 rows from a table. Which is the best choice among datareader or dataset?

0 Answers  


What is sta?

0 Answers  


What is a uri query?

0 Answers  


How to fetch a data from one table to another table in asp.net ?

0 Answers   MCN Solutions,


Explain asp.net mvc request life cycle? : asp.net mvc

0 Answers  


Categories