what is the difference between trigger and storedprocedures
- 16 Answers
- 29405 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / sunny kumar rana
1) A stored procedure can accept parameters while a trigger
cannot.
2) A trigger can’t return any value while stored procedures
depand on condition.
3) A trigger is executed automatically on some event while
a stored procedure needs to be explicitly called.
4) Triggers are used for insertions, update and deletions
on tables while stored procedures are often using
independently in the database.
5) A trigger cannot be written in a stored procedure.
However, the reverse is not possible.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to escape special characters in sql statements? : Sql dba
What is difference between ms sql and mysql?
What are sql objects?
What is view explain with example?
Why triggers are used?
What do we need to check in database testing?
Why truncate is used in sql?
What are different joins used in sql?
What are the features of pl sql?
How to run pl/sql statements in sql*plus?
What is the difference between microsoft sql and mysql?
Can I learn sql in a week?
What is lexical units in pl sql?
What is trigger types of trigger?
Is sql a microsoft product?
