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 full form of asp.net?
Explain the difference between value type and reference type?
what is the relation between delegates and events
How can u handle Un Managed Code Exceptions in ASP.Net?
Can you explain autopostback?
hi .net gurus here is my question " how does impersonate in asp.net works? explain with good example"
2 Answers PennyWise, TCS, Wipro,
What is the web.config file in asp?
What is the file through which you can customize your asp.net application?
What is the difference between <%#%> and <%=%>?
What is the significance of ASP.NET routing?
How does dataset acts in a disconnected fashion ?
About Global .asax ?
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)