1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

About writting a query and SP which is better ?

Question Posted / sweety

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 the different types of assemblies?

0 Answers  

How to communicate via Remote proxy with Client? a)MarshalByRef b)Marshal by Value or Any thing else?

0 Answers  

What is viewstate? What does the “enableviewstate” property do?

0 Answers  

What are httphandlers and httpmodules and difference between them?

0 Answers  

What is viewstate?

5 Answers   Microsoft,




What is the syntax for datagrid and specifying columns ?

2 Answers   Microsoft,

How to include silver light .xap page into asp.net web application and what is the purpose of using silverlight application?

0 Answers   CTS,

What is the life-span of the items in the viewstate?

0 Answers  

Name and describe some HTTP Status Codes and what they express to the requesting client ?

1 Answers  

What is AutoEventWireup attribute for ?

0 Answers  

what are the different ASP.NET Application Folders?

1 Answers   Wipro,

How do you store a value in viewstate and retrieve them?

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories