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
Explain what are the deferred execution and the immediate execution in linq?
Can "this" be used within a static method?
How will you load an assembly which is not referenced by current assembly?
Explain what is a delegate?
Is there any thread in our .net programs?
Explain when should you use .net web forms over asp.net mvc?
Differences between datagrid, datalist and repeater in .net?
What is a strong name in .net?
Is there any inbuilt tool or command provided by .NET to view the code inside the assembly?
Please explain what garbage collection is and how it works. Provide a code example of how you can enforce garbage collection in .net?
What is the difference between user control an custom control? Advantages/disadvantages?
Define satelite assembly?
Explain what is the difference between odbc and ado?
Is there built-in support for logging?
Explain what is immutability, what is it for and how is it codified?