hi
can any give me what are the major difference between [Stored Procedure / Trigger & Function] with example
kinds regards
There's no need for examples. The distinctions are very bold.
A stored procedure generally performs query's on one or more tables. i.e. UPDATE, INSERT, DELETE
A trigger is tied to one table and fires based on the type of trigger you use.
A function generally doesn't touch any table but simple performs a task such as complex calculations or string munipulation and returns a value.
Notice I use the term generally and I mean it very loosely. All of these can overlap but the choice of use is based on the desired task.
Adamus
sql
No comments:
Post a Comment