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 are the namespace available in .net?
What should you do to store an object in a viewstate?
How will you register com+ services?
What is .net assembly?
How is a managed code executed?
What is a formatter in .net?
What is heap and what is stack?
How do I spawn a thread?
What is lazy initialization?
What is the difference between response.write & response.output.write?
Please explain is the jit an interpreter?
Explain what relationship is between a process, application domain, and application?
State the differences between the dispose() and finalize().
How com+ related to the dna architecture?
What is an exe and a dll?