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
- 7066 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
Tell us what is the native image generator?
Difference between abstract class and interface in .net?
State the various features present in .NET?
Different between .net & j2ee ?
What is a .net class?
Is .net 4.8 backwards compatible?
what will do to avoid prior case?
Explain how to rename a table using sql queries?
When displaying fonts, what is the difference between pixels, points and ems?
Please explain what is a delegate?
what are connection strings?
What is the use of common language runtime?
Explain About GDI object ?
I want to serialize instances of my class. Should I use xmlserializer, soapformatter or binaryformatter?
What is connection pooling and how do you make your application use it?
