如何使触发器工作上只是最近的记录被插入?

Question

所以我正在编写一个触发器来检查输入的金额并显示信息。

Create trigger Trigoninsertpenalties
ON PENALTIES
after insert
AS
BEGIN
SELECT AMOUNT,
CASE
WHEN AMOUNT > 30 THEN 'The quantity is greater than 30'
WHEN AMOUNT = 30 THEN 'The quantity is 30'
ELSE 'The quantity is under 30'
END AS PENALTIES
FROM PENALTIES
End

问题是当我插入一个新记录时，结果，我得到了"金额列"的所有行。被显示。我只希望该触发器在我插入的新记录上工作，并仅为此显示结果。请帮助。插入新记录查询!

Insert INTO PENALTIES
VALUES (101,104, '08-03-1998',50)

Answer 1

将触发器改为使用INSERTED:

Create trigger Trigoninsertpenalties
ON PENALTIES
after insert
AS
BEGIN
SELECT AMOUNT,
CASE WHEN AMOUNT > 30 THEN 'The quantity is greater than 30'
WHEN AMOUNT = 30 THEN 'The quantity is 30'
ELSE 'The quantity is under 30'
END AS PENALTIES
FROM INSERTED
End