Now my SQL table FIXALARMS due to application of the associated some must begin with "IDS -" statements have been frequent inserts, due to the application package cannot be modified, I would like to through some way to prohibit contains SQL "IDS -" insert statement, is there any way to achieve?

CodePudding user response:
Use the trigger, or with a check constraintCodePudding user response:
Use a trigger may better interoperability,But the front-end system error, the original poster pocket don't have to live?

CodePudding user response:
Using insteadof trigger!