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
- 6904 Views
- I also Faced
- E-Mail Answers
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
Do you know what is the difference between an abstract class and an interface?
When we use windows api in .net is it managed or unmanaged code?
What is Entity Relationship Model in .NET?
How does cas works?
What is the difference between response.write & response.output.write?
Explain about .net assemblies?
What is .net core used for?
How can you instantiate a tuple?
Explain the difference between public and static modifiers?
i had attended to infosys interview on 17th april 2010...on .net..3+ experience for Technology Analyst .. to my knowledge i did well in technical and hr whether i loose the interview or still processing is taking place..am confused please. what accuatly would be happend?
How to load a user control dynamically in runtime?
Explain soap and xml?
Explain the .net framework overview?
What is the difference between function and stored procedure?
Differentiate between managed and unmanaged code?
