Difference between Trigger and Stored Procedure

1. Stored procedures cannot run automatically, they have to be called explicitly by the user.But triggers are executed automatically when particular event (like insert, update, delete) associated within the database object (like table) gets fired. 
2. Stored procedures can be scheduled through a job to execute on a predefined time, but we can't schedule a trigger.
3. Stored procedure can accept the parameters from users whereas trigger cannot accept parameters from users.
4. We can use the transaction statements like begin transaction, commit transaction and rollback inside a stored procedure but we can't use the transaction statements inside a trigger. 
5. A Trigger can call the specific Stored Procedures in it, but the reverse is not true.

Posted in: SQL,SQL Interview