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 |
Should validation (did the user enter a real date) occur server-side or client-side? Why?
How do you register JavaScript for webcontrols ?
Explain the page lifecycle of an asp.net mvc? : asp.net mvc
What is ISAPI?
What is the request flow used for asp.net mvc framework? : asp.net mvc
What is strong name and which tool is used for this ?
To bind columns manually which tags do you need to add within the asp:datagrid ?
What is ViewState ? and how it is managed ?
hi im shailendra singh my question is how we deploye the data base
Explain about asp.net caching?
Write a code for passing ArrayList in Web API?
what is view stat how it is use ?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)