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 |
Explain Features in ASP.NET
i want to develope a page for online test using asp.net with c#.net. so, how to insert the questions in the database sqlserver2000 and how to pick the questions randomly when user login for test. plz send the code for this....
3 Answers Chaitanya, Crysalis, CTS, HCL, Sein Infotech, TCS,
What is a 404 redirect?
The technical part was on ASP.Net only of web services.
Explain autherization levels in .net ?
When is an object collected by the Garbage Collector? [Four options were given]
What is the Difference between Web.config and global.asax? Can we write connection String code in global.asax?
In a webservice, need to display 10 rows from a table. Which is the best choice among datareader or dataset?
What is sta?
What is a uri query?
How to fetch a data from one table to another table in asp.net ?
Explain asp.net mvc request life cycle? : asp.net mvc