What is difference between triggers and stored procedures.
And advantages of SP over triggers ?
- 4 Answers
- 23766 Views
- Microsoft, TCS, I also Faced
- E-Mail Answers
Answer Posted / anil_abbireddy
1. Triggers are Table dependent,But Procedures are Not
2. We can not pass Parameters through Triggers,But in case
of sp we can pass no.of parameters
3. We can not execute triggers explicitly,but ps we can
4. we can not place transaction processing statments in
triggers(commit,collback,save point), but in ps. we can
5. we cannot overload triggers, but we can overload
functions & procedures using packages.
| Is This Answer Correct ? | 44 Yes | 8 No |
Post New Answer View All Answers
how would concatenate strings in mysql? : Sql dba
Does inner join return duplicate rows?
What is the most common sql injection tool?
Why do we go for stored procedures?
Can we write dml inside a function in sql server?
What is a ddl command?
Mention what are different methods to trace the pl/sql code?
how to rename an existing column in a table? : Sql dba
How do I tune a sql query?
Does mysql support pl sql?
What is 19 null in sql?
What is the need of merge statement?
Explain what is sql*plus?
What are sql built in functions?
Explain what is a field in a database and record in a database?
