what is the difference between trigger and storedprocedures
- 16 Answers
- 29539 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / srikanth
Trigger will fire when the condition arises but the stored
procedure will execute when the user or main programme
wants its need.
triggers can't accept parameters from users whereas stored
procedures can accept parameters from users.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to include numeric values in sql statements? : Sql dba
Explain ddl statements in pl/sql?
What is the execution plan in sql?
how to enter binary numbers in sql statements? : Sql dba
explain advantages of innodb over myisam. : Sql dba
What is primary and foreign key?
What is dba in sql? : SQL DBA
how to enter numeric values as hex numbers? : Sql dba
what are ddl statements in mysql? : Sql dba
Show the cursor attributes of pl/sql.
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
Which is faster truncate or drop?
What is the size of partition table?
describe mysql connection using mysql binary. : Sql dba
Is sql an operating system?
