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
- 25207 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
What is nosql vs sql?
What is %s in sql?
How can one get sql*loader to commit only at the end of the load file? : aql loader
what is a trigger? : Sql dba
Explain isolation levels. : Transact sql
What company owns postgresql?
how can you see all indexes defined for a table? : Sql dba
Which is the correct statement about truncate and delete?
How many sql databases can you have on one server?
What is benefit of creating memory optimized table?
Explain what is a subquery ?
What does the file extension accdb stand for?
How does a covering index work?
What is difference between primary and secondary key?
Can we use join in subquery?
