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 ?
- 3 Answers
- 5729 Views
- I also Faced
- E-Mail Answers
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 all type of application can u make with visual studio?
1 mor thing guyz....can i go for C# directly without C++ /JAVA knowledge for dot net ..???
What are the new features in .net core?
How anonymous method is different from a lambda expression?
What are the deferred execution and the immediate execution in linq?
Explain me what is a design pattern and what is it for?
How many types of generations are there in a garbage collector?
Explain the different types of proxy patterns?
Difference between machine.config and web.config?
Should I implement finalize on my class? Should I implement idisposable?
Describe ways of cleaning up objects.
How to implement datagrid in.net? How would you make a combo-box appear in one column of a datagrid? What are the ways to show data grid inside a data grid for a master details type of tables? If we write any code for datagrid methods. What is the access specifier used for that methods in the code behind file and why?
Dot Net Framework 
