Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and storedprocedures
- 16 Answers
- 32362 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 a table in a database?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is memory optimized?
What is trigger in sql and its types?
Explain correlated query work?
what are the difference between clustered and a non-clustered index? : Sql dba
What is the difference between having clause and where clause?
what is a join? : Sql dba
What is a left join?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is sqlservr exe?
What is sap sql?
Can we use ddl statements in stored procedure?
What is record in pl sql?
Why is a trigger used?
