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
- 25407 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
Explain the working of primary key?
What is the meaning of disabling a trigger?
what is a composite key ? : Sql dba
What is the plv (pl/vision) package offers?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What are the benefits of stored procedures?
What is %type in pl sql?
How to display the current date in sql?
What does trigger mean in psychology?
What is before trigger?
How much ram can sql express use?
What are the advantages of stored procedure?
What is use of term?
What are sql indexes?
What are the types of dbms?
