What is difference between triggers and stored procedures.
And advantages of SP over triggers ?
- 4 Answers
- 23761 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
When to use inner join and left join?
What is relationship? How many types of relationship are there?
What is range partitioning?
What is column?
What is data control language?
What is the use of double ampersand (&&) in sql queries? Give an example
How many row comparison operators are used while working with a subquery?
What is materialized view. What are different methods of refresh?
How is a process of pl/sql compiled?
how to convert numeric values to character strings? : Sql dba
What is record type in pl sql?
What are the set operators in sql?
What is a recursive join sql?
What is the use of function in sql?
what is a database lock ? : Sql dba
