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 is a boolean in sql?
How many times can we commit in a loop?
What is a left inner join?
What is the purpose of a secondary key?
how to calculate the difference between two dates? : Sql dba
Does google use sql?
what is acid property in database? : Sql dba
What is out parameter used for eventhough return statement can also be used in pl/sql?
How do you use a while loop in pl sql?
When sql appeared?
What is cte sql?
What is a temporal table?
What are synonyms in sql?
Is primary key clustered index?
What is Materialized View? In What Scenario we Use Materialized View?