Difference between Triggers and Stored Procedure
- 23 Answers
- 74826 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / bed singh
1. Triggers can only be implemented on tables or views but
Stored Procedure in independent code that can be specific
to database.
2. Triggers are automatically run but stored procedures are
not automatically run and they have to be called explicitly
by the user.
3. we can write a stored procedure within a trigger but
cannot write a trigger within a stored procedure.
4. Trigger is attached to table or view and is fired only
when an INSERT, UPDATE, and/or DELETE occurs, while a
stored procedure executes at any time when it is called.
| Is This Answer Correct ? | 75 Yes | 9 No |
Post New Answer View All Answers
Equi join and non equi join is possible with sql server?
Explain “row_number()” in sql server with an example?
What are the kinds of subquery?
What are the source of constraints?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How to connect php with different port numbers?
What is subquery? Explain the properties of a subquery?
Why should you use or avoid select * statements?
What is a coalesce function?
How to rebuild the master database?
How to convert numeric expression data types using the cast() function?
How can we solve concurrency problems?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Does view occupy space?
What is sql server query analyzer?
