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 |
Is there built-in support for logging?
How does u handle this COM components developed in other programming languages in .NET?
What is Nothing permission set in .Net
How do you create threading in.net?
1.What is the major advantage of polymorphism? Please don't simply say binding. Specify any other reason.
How to produce an assembly?
What is meant by localization?
Explain what is a delegate?
how can i create a table from front end to back end in wabe page?
What is the difference between a namespace and assembly name in .net?
What are the features of dot net?
What is the use com component in .net?