Stored Procedure: This is nothing but an executing your business logic.
It can perform multiple DML (insert,update,delete) operation in single execution.
One Stored procedure can be called another stored procedure.
Basically it may or may not return data using Cursors.
We can keep Commit and Rollback
Function : A Function is used work for a small calculations.
It is expecting an input and producing must single out put value( like aggregate functions take multiple values for average of salaries and provide one value).
A function can be call in a Select command but stored procedure can not call.
Cannot accept Transaction statements like(Commit and RollBack)
Trigger : It is event fire based on the DML operation performed on a table.
Ex: If Table having any updation using insert operation immediate TableB having delete operation will occur.
Dn2010, if this helps please login to Mark As Answer. | Alert Moderator