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 ?

Answer Posted / ravinder kumar

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between dispose and finallize method?

645


What is Event - Delegate? clear syntax for writing a event delegate

1530


What is an exe and a dll?

574


What are the difference bbetween value type & reference types ? Example from .net. Integer & struct are value types or reference types in .net?

493


Tell me about secure socket layer? How to make use of the technology?

535






How is a managed code executed?

684


Explain the procedure to add assemly to gac to make it shared one?

543


What are situations when you register .NET assembly in GAC ?

630


What is assemblies in .net?

595


What is lambda expressions in c#?

583


What is the lapsed listener problem?

682


Is it true that objects don't always get destroyed immediately when the last reference goes away?

541


Is atl redundant in the .net world?

536


Please explain the difference between constants and read-only variables?

508


How to implement getcommon method in class a? Are you seeing any problem in the implementation?

600