what is the use of stored procedure which has only one
select statement over simple select statment query ? Why to
write a stored procedure then ?
- 3 Answers
- 6306 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Because stored procedure are pre compiled and need not to
compile again .it is faster than simple query.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / hardik
execution of the stored procedure is faster than simple sql
statement query.
for e.g.
select * from tablename is simple sql statement
create proc temp
as
begin
select * from tablename
end
above is sp of that statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Is .net is a language?
I'm having some trouble with cas. How can I troubleshoot the problem?
Explain assemblies in .net?
Explain about .Net products?
Do you know the difference between the stack and the heap?
What makes .net core cross platform?
What are channels in .NET Remoting?
i have 2 functions, int add(int a,int b); double add(int a,int b); does this code implement overloading? if not what will be the error?
How WSDL is stored ?
What is Event - Delegate? clear syntax for writing a event delegate
Should I implement finalize on my class? Should I implement idisposable?
How to create properties and methods using controls?
Dot Net Framework 
