Answer / 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 to check if a record exists in a mysql database php?

0 Answers  

---

What is the difference between having and where clause in mysql? Explain

0 Answers  

---

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

0 Answers  

---

How do I quit mysql?

0 Answers  

---

What is mysqli_select_db?

0 Answers  

---

What is trigger in mysql?

0 Answers  

---

How can you count the total number of records of any table?

0 Answers  

---

When to use order by in delete statement?

0 Answers  

---

For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.

1 Answers  

---

What is mysql protocol?

0 Answers  

---

What is a blob datatype?

0 Answers  

---

SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,

---