Originally posted by BrilloPad
View Post
A trigger can catch those inserts or updates which break the business rules, return an error and rollback the insert/update.
It makes more sense to put that sort of constraint in the table/view trigger than having to define than allow potentially bad data into the table and always trust other applications to behave properly.
Comment