what is the difference between trigger and storedprocedures
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 are the different tables present in mysql? : Sql dba
What is the most restrictive isolation level? : Transact sql
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
how many columns can be used for creating index? : Sql dba
Explain the methods used to protect source code of pl/sql.
What do you know by pl/sql cursors?
how can we submit a form without a submit button? : Sql dba
What is the difference between instead of trigger and after trigger?
What does count (*) mean in sql?
what are the different type of normalization? : Sql dba
What are the types of sql commands?
Can we create table in function?
what are the differences between char and varchar? : Sql dba
What are the different sql commands?
Is keyword pl sql?