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
- 25588 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 rank function in sql?
how to start mysql server? : Sql dba
Define the select into statement.
What are pl/sql packages?
Does sap use sql?
Can cursors be part of a trigger body?
What is sqlca in powerbuilder?
What are analytical functions in sql?
What are the events on which a database trigger can be based?
Can we create foreign key without primary key?
What is a unique key and primary key and foreign key?
what is the difference between where clause and having clause? : Sql dba
What are few of the schema objects that are created using PL/SQL?
Is sql better than access?
Explain architecture of sql server notification services?
