About writting a query and SP which is better ?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
What is the difference between web config and machine config files?
What are the different methods of session maintenance in asp.net?
What is synchronous and Asynchronous post back ?
Why session is more secure than cookies?
Explain Areas in MVC?
What is the use of HttpHandlers? When to use this?
To match the two different controls which control would we use ?
How much is the pay-for-use service if I chose not to use microsoft-sponsored advertising?
How to store a dataset in a viewstate?
How can we update records in gridview?Is there any appropriate code for it?
What are session state modes? List some of the important session state modes of asp.net.
what is new debug tools in asp.net ?