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

Explain what are the deferred execution and the immediate execution in linq?

801


Can "this" be used within a static method?

826


How will you load an assembly which is not referenced by current assembly?

772


Explain what is a delegate?

812


Is there any thread in our .net programs?

855


Explain when should you use .net web forms over asp.net mvc?

734


Differences between datagrid, datalist and repeater in .net?

773


What is a strong name in .net?

817


Is there any inbuilt tool or command provided by .NET to view the code inside the assembly?

813


Please explain what garbage collection is and how it works. Provide a code example of how you can enforce garbage collection in .net?

773


What is the difference between user control an custom control? Advantages/disadvantages?

791


Define satelite assembly?

775


Explain what is the difference between odbc and ado?

732


Is there built-in support for logging?

856


Explain what is immutability, what is it for and how is it codified?

771