Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and storedprocedures
- 16 Answers
- 32415 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / nancy
BASIC DIFFERENCE IS trigger is automatically executed without an action required by a user where as stored procedure needs to be explicitly invoked...
a database TRIGGER ia a STORED PROCEDURE that is fired when an insert,update or deletestatements is issued against the associate table.a trigger is fired whwn database related event occurs....
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is the stuff function and how does it differ from the replace function? : Sql dba
how to check server status with 'mysqladmin'? : Sql dba
What is mutating error in pl sql?
Can pl sql procedure have a return statement?
How to write pl sql program in mysql command prompt?
What does sign mean sql?
How many row comparison operators are used while working with a subquery?
How many types of cursors are available in pl/sql?
What are the different schemas objects that can be created using pl/sql?
What is sql not null constraint?
How many sql commands are there?
what is the use of friend function? : Sql dba
What pl/sql package consists of?
How to assign sql query results to pl sql variables?
What is inner join in sql?
