Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and storedprocedures
- 16 Answers
- 32492 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
What is a Mapplet?
What is the usage of nvl function?
Why do we go for stored procedures?
How show all rows in sql?
how to create a new view in mysql? : Sql dba
How to handle bulk data?
What is difference between sql and excel?
Can I call a procedure inside a function?
What is the syntax and use of the coalesce function?
How many rows can sqlite handle?
Explain autonomous transaction.
What happens when a trigger is associated to a view?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is dialect in sql?
What is bind variable in pl sql?
