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 ?
Answers were Sorted based on User's Feedback
Because stored procedure are pre compiled and need not to
compile again .it is faster than simple query.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
What are .net applications?
Is string a value type or a reference type?
What is the use of edititem template ingridview?
1 Answers C Squared Systems, Microsoft,
Please explain what are an inheritance, polymorphism, and encapsulation?
What is a delegate in .NET?
What are the different types of Classes in .NET?
What is func in .net 3.5?
Which Namespace is used to to achieve MultiThreading in .NET?
What is Assembly manifest? what all details the assembly manifest will contain.
What is the difference between boxing and unboxing?
What is the best way to crack the certification?
What is dot net architecture?