What's the purpose of Stored Procedure?

Answer Posted / manisha

Stored procedured are precompiled and preoptimized sql stmts
so it takes less processing time,means executes much faster.
Can be shared between multiple user,so more reusable.
Much easier to manage it,since it resides in DB
more secure,flexible

Is This Answer Correct ?    16 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How ssrs maintain security?

572


Can you pass expressions to stored procedure parameters?

499


What is best institute to Learn DotNET And SQL in chennai?

1686


mention different types of relationships in the dbms?

501


What is the ‘fillfactor’?

563






What is the difference between mysql and mysqli?

580


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

537


Explain the database you used in your final year project?

532


What are the basic features of a trigger in ms sql server?

565


What are the filtered indexes?

594


What is usually the first word in a sql query?

591


Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

492


What is mscorsvw.exe - process - microsoft .net framework ngen?

518


How is sql server used?

544


What is format parameter in ssrs?

109