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
- 7084 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 |
What are the new features in .net core?
Do I have any control over the garbage collection algorithm?
What is CCW (COM Callable Wrapper)
Which namespace is require to used XML in .NET?
0 Answers Sans Pareil IT Services,
Is there a way to suppress the finalize process inside the garbage collector forcibly in .net?
What is the base class of Button control in .NET?
Can we share session between ASP.Net & ASP
3 Answers Accenture, Value Labs,
What is smart navigation?
Name for built-in permission sets in .Net
Please explain what is the difference between encrypting a password and applying a hashing?
How to debug failed assembly binds?
What is different between Web User Control and Web Custom Control?
Dot Net Framework 
