大佬们,表名为DrawingNo_A,字段id自增长,Employee_name、Create_Date为要插入数据的字段,EFFE_Tag默认值1,Drawing_Type默认值为A, 写了个触发器设置id大于3就不能插入了,但是没生效,大佬们帮看看是不是写法的问题。 触发器是这么写的: USE [RD_Drawing] GO /****** Object: Trigger [dbo].[trg_check_id_max] Script Date: 2024/6/18 11:43:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[trg_check_id_max] ON [dbo].[DrawingNo_A] INSTEAD OF INSERT AS BEGIN SET NOCOUNT ON; IF EXISTS (SELECT 1 FROM inserted WHERE ID > 3) BEGIN RAISERROR('Inserted ID is greater than the maximum allowed value.', 16, 1); RETURN; END
-- 如果检查通过,则正常插入数据 INSERT INTO DrawingNo_A(Employee_name,Create_Date) SELECT Employee_name,Create_Date FROM inserted END |
最佳回答 |
||||
0
|
|