undefined | Better HN

0 pointscandiddevmike11mo ago0 comments

How do you handle trigger logic that compares old/new without having a round trip back to the application?

0 comments

3 comments · 1 top-level

SoftTalker11mo ago· 2 in thread

Do it in a stored procedure not a trigger. Triggers have their place but a stored procedure is almost always better. Triggers can surprise you.

I don't follow how you would do that in a stored procedure outside of a trigger.

I think instead of performing an INSERT you call a stored proc that does the insert and some extra stuff.

j / k navigate · click thread line to collapse