Author : MD TAREQ HASSAN
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 |