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

Answer / vickys & sugan

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

Answer / surendra

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

Answer / amit patel

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

Answer / anand

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

What is the difference between Server.Transfer and Response.Redirect? Why would you choose one over the other?

26 Answers   Syntax Softtech,

How use Xml data in ASP.net?

0 Answers   MCN Solutions,

can u debug application programatically? if yes how?

0 Answers   FactorH,

You have two buttons in web form and i clicked on one of the button, so how do i find which button i've clicked on the form in my page load?

15 Answers   INDUS,

True or False: A Web service can only be written in .NET?

5 Answers  

What is application and session in asp.net?

0 Answers  

Can the validation be done in the server side? Or this can be done only in the Client side?

2 Answers  

About Global .asax ?

6 Answers   Satyam,

What is the difference between adding reference in solution explorer and adding references by using ?

0 Answers  

What is asp.net mvc5? : Asp.Net MVC

0 Answers  

When is the ViewState available during the page processing cycle ?

6 Answers   Siebel,

What are the media types of http requests and response?

0 Answers