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 web api and why to use it?
Explain MVC model binders?
Is there any property names “isnavigating”?
How do you use a custom validator? When might you want to use one?
what is the exact purpose of http handlers and interfaces?
How we can kill our Session in web farm where there is no any sticky server .And user can not Logout bcoz of that.
Will the asp.net validators run in server side or client side? How do you do client-side validation in .net?
Is asp.net a programming language or framework?
Explain the use of dataadapter.
Can we make activex dll also ti execute in some process as that of client ? How can we do?
Types of optimization and name a few and how do u do?
If you have to replicate a set of controls(UI) across a number of web pages, what will you do
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)