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


Please Help Members By Posting Answers For Below Questions

What do the terms “boxing” and “unboxing” mean?

736


Is .net core managed code?

741


What is the native image generator?

823


Explain what is the difference between response.redirect & server.transfer?

783


Explain Creational design pattern in .NET?

818


Explain the different parts of an assembly?

786


What is the use of gacutil.exe?

873


What is il in vb.net?

792


Explain dataset.acceptchanges and dataadapter.update methods in .net?

769


In code behind class, name the type of code found. Is it the server side code or client side code?

1010


What is the difference between response.write & response.output.write?

806


Explain what is the difference between web application and enterprise application?

784


How can I get at the win32 api from a .net program?

778


How to instantiate a delegate?

1845


When we go for html server controls and when we go for web server controls?

787