Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and storedprocedures
- 16 Answers
- 32939 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 the basic form of sql query?
What is set transaction?
How do I view a sql trace file?
What is null in pl/sql?
Why having clause is used in sql?
What is server name sql?
What type of database is sql?
What is sql*loader and what is it used for?
What is where clause in sql?
What are the different dml commands in sql?
What is pivot in sql?
Mention what does plv msg allows you to do?
What is rollback?
What is a column in a table?
What is primary key in db?
