About writting a query and SP which is better ?

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

Question Posted / sweety

5 Answers
9641 Views
Abacus, Satyam, I also Faced
E-Mail Answers

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

What is mvc in asp.net interview question? : Asp.Net MVC

0 Answers

How response object is related to asp's response object?

0 Answers

Name the two properties are on every validation control?

0 Answers

What is the use of autowireup in asp.net?

0 Answers

Where do you store the information about the user?s locale?

1 Answers

Is web config mandatory?

0 Answers

Can you store dataset in viewstate?

7 Answers Microsoft,

Explain the difference between codebehind="mycode.aspx.cs" and src="mycode.aspx.cs"?

0 Answers

WHAT IS THE SEQUENCE IN WHICH ASP.NET EVENTS IS PROCEED?

4 Answers

What is application and session in asp.net?

0 Answers

How to use class library reference in asp.net project? Can you give me the example with source Class library haves classes like Database, insert, update, delete, reflection how can i use the database class connection in insert class to insert the record in to the Main Project in asp.net.

1 Answers

what is Theme in Asp.net 2.0

1 Answers Syntel,

For more ASP.NET Interview Questions Click Here