What's the difference between a stored proc and a trigger?
One, A stored proc if not re-compiled when size gets bigger ends up being the most fastest db object on the planet to handle :).
Two, A trigger on the other hand if not used with the right situtation, you end up shootin yourself in the head :).
Thanks,
Always remember to use Stored procs for highly user responsive events for optimized performance.
And use Triggers only when needed :), otherwise you may end up like our buddies in the Tale of two Database Objects :)
Happy DB Programming ;)
|
No responses found. Be the first to respond and make money from revenue sharing program.
|