What are advantages of Stored Procedures?

Answer Posted / greatasoft-mani.b

Stored Procedure's are precomplied one. When ever you call
a stored procedure it generate the result faster than
ordinay coding. The improve the performance of the
application i.e to reduce the time stored procedure's are
used

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between cluster and non cluster index? : Sql dba

730


What types of commands can be executed in sql*plus?

764


explain primary keys and auto increment fields in mysql : sql dba

709


What is set transaction?

765


what is an index? : Sql dba

720






Write the alter statement to enable all the triggers on the t.students table.

847


What is the sql query to display the current date?

753


how to create a table index in mysql? : Sql dba

749


What is rollback?

786


What is full join in sql?

713


explain what is mysql? : Sql dba

787


what are the advantages of using stored procedures? : Sql dba

822


what is uncommittable transactions? : Transact sql

752


How can I change database name in sql?

703


What is sqlca in powerbuilder?

746