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
- 6882 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is .net and .net framework?
What is the concept of inheritance and how it works in .net?
What is the difference between reference type and value type?
Does .net supports destructors concept?
what is the meaning silverligt control
What is managed code in .NET?
What is immutability?
What are the important components of .net?
How big is the datatype int in .net?
What is singleton activation mode in .net?
What is marshling?
Explain the difference between the stack and the heap?
Write the .net syntax for 'while loop'?
How to convert a .NET object into COM operabililty?
Which namespace is used to support multithearding in .NET?
