Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6902 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 Driver Script any how related to AOM?
What is the concept of inheritance in .net?
Difference between value type & reference types ?
Explain what is the difference between a class and an object, and how do these terms relate to each other?
If we want to write a Windows service that cannot be paused, only started and stopped. How to accomplish that?
How can I get at the win32 api from a .net program?
What is the difference between a debug and release build?
What is the difference between a namespace and assembly name in .net?
Explain me what is the difference between a class and an object, and how do these terms relate to each other?
How would ASP and ASP.NET apps run at the same time on the same server?
How server form post-back works?
What is a strong name in .net?
Dot Net Framework 
