=> We can execute a stored procedure whenever we want with the help of the exec command, But a trigger can only be executed whenever an event ( Insert,delete and update ) is fired which the trigger is defined.
=> We can call a stored procedure from inside another stored procedure but we can't directly call another trigger within a trigger.
=> Stored procedure can be scheduled through a job to execute on a predefined time. But we can't schedule a trigger.
=> Stored procedure can return a value. But trigger can't return a value.
0 comments:
Post a Comment