你可以使用以下语句来创建一个在表hangye上触发器,当列行业编码新增重复时提示行业编码重复:
CREATE TRIGGER tr_hangye_industrycode
ON hangye
FOR INSERT
AS
BEGIN
IF EXISTS (SELECT industrycode FROM hangye WHERE industrycode IN (SELECT industrycode FROM inserted))
BEGIN
RAISERROR ('行业编码重复', 16, 1)
ROLLBACK TRANSACTIO