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
- 6877 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 managed and unmanaged code in .net?
3 Answers Deltech, Dhanush Infotech,
What is different between webusercontrol and in webcustomcontrol?
What data providers available in .net to connect to database?
What is Complex Class in .NET?
Difference abstract class and interface in .net?
What are the collections you've used?
Is string a value type or a reference type?
What is close method? How its different from finalize and dispose?
Compare client server application with n-tier application
What is the use of Treeview control?
What is multiThreading in .NET?
diff between forms authentication and windows authentication?
Dot Net Framework 
