22,209
社区成员
发帖
与我相关
我的任务
分享
IF EXISTS(SELECT *
FROM table1, inserted
WHERE table1.img = inserted.img
AND table1.inq_date >= inserted.inq_date
AND table1.id < inserted.id) -- 漏了个条件,当前记录没有排除
ROLLBACK TRANSACTION
CREATE TRIGGER tr_ins_table1
ON table1
FOR INSERT
AS
BEGIN
IF EXISTS(SELECT *
FROM table1, inserted
WHERE table1.jmg = inserted.jmg
AND table1.inq_date >= inserted.inq_date)
ROLLBACK TRANSACTION
DECLARE @last_time int
SET @last_time = (SELECT MAX(t.times)
FROM table1, inserted
WHERE table1.jmg = inserted.jmg)
IF (@last_time IS NULL)
SET @last_time = 0
UPDATE table1
SET table1.times = @last_time + 1
FROM table1, inserted
WHERE table1.id = inserted.ID
END