What is difference between triggers and stored procedures.
And advantages of SP over triggers ?
- 4 Answers
- 23730 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 cursor status?
How to set up sql*plus output format in oracle?
Name the operator which is used in the query for pattern matching?
Which nosql database is best?
How do you declare a user-defined exception?
Is crud a cuss word?
What is the difference between function and procedure in pl/sql?
What is full join in sql?
What is the primary use of normalization?
What does select top 1 do in sql?
What will you get by the cursor attribute sql%rowcount?
What is inner join in sql?
What are sql built in functions?
Does sql profiler affect performance?
What is a nested table in word?
