Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of stored procedures, triggers,
indexes?
- 5 Answers
- 33306 Views
- I also Faced
- E-Mail Answers
Answer Posted / jeyakumar
stored procedure:
Stored procedure is a collection of sql statements.It is precompiled one so execution time is fast.Single name we can create procedure for insert,delete,update.
Triggers:
Mainly used for implementing business rules.It execute automatically when the particular event is fired. For example maximum record 100 if anybody try to insert after 100 then delete first come record(first come first out).
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is a result set object?
How do I view tables in mysql workbench?
Explain % and _ inside like statement?
What is dbms in mysql?
How will you export tables as an xml file in mysql?
What is row locking in mysql?
What does it mean to be case sensitive?
How we can get the current date in mysql?
How do you create a table in mysql workbench?
What does schema mean?
What is mysqli_free_result?
How many TRIGGERS are allowed in MySql table?
What are the column comparisons operators?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
How to make a column bigger and delete unique from table.
