Answer Posted / hrindows@gmail.com

 Stored Procedure increases the performance of the applications. Once stored procedures are created, they are compiled and stored in the database.
 Stored procedure reduces the traffic between application and database server. Because the application has to send only the stored procedure's name and parameters instead of sending multiple SQL statements.






 Stored procedures are reusable and transparent to any applications.
 A procedure is always secure. The database administrator can grant permissions to applications that access stored procedures in the database without giving any permission on the database tables.

How is data stored in mysql?

685

---

How to define numeric 9(3) in db2 table without decimal point??

2608

---

How many ways to get the current time?

717

---

Why to use char instead of varchar in the database?

785

---

What is myisamchk?

708

---

How to increment dates by 1 in mysql?

758

---

What is the difference between sql and mysql and oracle?

633

---

How to run a sql statement?

746

---

What are the steps required to view your mysql database?

838

---

How to rename an existing table in mysql?

719

---

What is a user defined variable?

690

---

what are the different tables present in mysql? : Mysql dba

689

---

How To see all the tables from a database of mysql server.

765

---

In which language mysql has been written?

1064

---

What are the purposes of using enum and set data types?

700

---