What are the advantages of stored procedures, triggers,
indexes?
- 5 Answers
- 33912 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
