About writting a query and SP which is better ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between union and join?

573


How Session outproc in Sqlserver stored?

2312


What are client activated objects?

567


Why web api is better than wcf?

571


Can we handle the error and redirect to some pages using web.config?

931






What is http post and http get?

552


Why would anyone need to implement their own hashtable or linked list?

2451


Give 2 examples for scenarios when routing is not applied?

607


What are the two types of web pages?

526


What is a server farm in iis?

548


If you want to write your own dot net language, what steps you will you take care?

531


Explain the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc

524


What is fulltrust?

569


What is Partial PostBack in ASP.NET?

616


How can you use a custom controls in ASP.NET application?

558