Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between triggers and stored procedures.
And advantages of SP over triggers ?
- 4 Answers
- 25426 Views
- Microsoft, TCS, I also Faced
- E-Mail Answers
Answer Posted / jaya
1) Stored procedures can accept parameters and can return values. Triggers can neither accept parameters nor return values.
2) A Trigger is dependent on a table and the application has no control to not fire a trigger when not needed. On the other hand, a stored procedure can be called as needed.
3) Procedure runs only when one call them manually whereas a trigger runs when there is any activity(insert,update,delete) on table on which the trigger is written.
4) Firing of a stored procedure can be controlled whereas on the other hand trigger will get fired whenever any modification takes place on the table.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the difference between rollback and rollback to statements?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What are crud methods?
Which sorts rows in sql?
How long does it take to learn pl sql?
What is trigger in sql?
What is difference between mysql and postgresql?
Explain autonomous transaction.
what are the differences between require and include, include_once and require_once? : Sql dba
What is the basic structure of an sql?
What are the types of records?
How much does sql cost?
what is normalization? : Sql dba
What are the types of subqueries?
What is join view in sql?
