Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7171 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 is Application Domain?
What is difference between .net and .net core?
Which server tag comes from server when we submit any data
How to spawn a thread?
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 ?
What does SCM do?
What is Global Assembly Cache (GAC) and what is the Purpose of it?
How can you automatically generate interface for the remotable object in .NET with Microsoft tools?
What is Ajax design pattern in .NET?
How will you load an assembly which is not referenced by current assembly?
What is garbage collection and how it works. Provide a code example of how you can enforce garbage collection in .net?
I am looking for a fast track course (MAX 15 days) in MS.NET 3.5 and SQLSERVER 2005 in hyderabad or mumbai or pune. I am working in mumbai so cannot gor for long course. Can any body suggest me the best couching class or best faculty for the same. Thanks.
Dot Net Framework 
