Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and storedprocedures
- 16 Answers
- 32418 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 temp table?
What are the two types of periodical indexes?
Can you do multiple joins in sql?
What is the difference between local variables and global variables?
Is hadoop a nosql?
What is sqlerrm?
What is date functions?
What is a temporal data type?
Which tcp/ip port does sql server run?
Show how functions and procedures are called in a pl/sql block.
How does a self join work?
What program will open a mdb file?
What is rank function in sql?
What is sorting in sql?
What do you think about pl/sql?
