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 ?
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 the base class of Button control in .NET?
What is finalize method in .net?
Please explain what are an object and a class?
Explain about the Common Language Runtime?
Explain how com+ related to the dna architecture?
What is reflection and what is it for?
What's wrong with a line like this? Datetime.parse(mystring);
Where does the gac exist ?
What is the benefit of .net core?
Explain boxing and unboxing in .net.
What is the difference between a class and an object, and how do these terms relate to each other?
Explain the difference between the stack and the heap?
Write the .net syntax for 'while loop'?
What is gac in .net?
State some of the different languages supported by .net?