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
- 7072 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 is the difference between asp.net and asp?
What are the different types of remote object creation mode in .net?
What is .net and why it is used?
Can I write il programs directly?
What is the difference between reference type and value type?
How can you turn-on and turn-off cas?
Tell us the differences between an interface and an abstract class in .net?
What is the difference between vb.net and vc#.net?
Explain how to redirect tracing to a file?
What is different between User Control and Web Control and Custom Control?
What are Satellite Assemblies? How you will create this? How will you get the different language strings?
What are the advantages of .net?
Dot Net Framework 
