Home > database >  O god! Insert SQL table how to prohibit certain text
O god! Insert SQL table how to prohibit certain text

Time:11-09

Such as:
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 constraint

CodePudding 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!
  • Related