Author : HASSAN MD TAREQ

Similarity

  • All of these are database objects containing code that will be executed as a single unit
  • triggers, functions, and stored procedures are typically written in a T-SQL, but they can also be implemented in any of the .NET languages like C# or VB.NET.

Differences

  triggers stored procedures functions
change data yes yes no
return value never sometimes always
how they are called on event exec in a statement