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 do the terms “boxing” and “unboxing” mean?
Is .net core managed code?
What is the native image generator?
Explain what is the difference between response.redirect & server.transfer?
Explain Creational design pattern in .NET?
Explain the different parts of an assembly?
What is the use of gacutil.exe?
What is il in vb.net?
Explain dataset.acceptchanges and dataadapter.update methods in .net?
In code behind class, name the type of code found. Is it the server side code or client side code?
What is the difference between response.write & response.output.write?
Explain what is the difference between web application and enterprise application?
How can I get at the win32 api from a .net program?
How to instantiate a delegate?
When we go for html server controls and when we go for web server controls?