大家能帮我看一下这个触发器吗?如果我批量插人记录 就会出错
CREATE TRIGGER [Tr_DNFNO] ON [dbo].[DisNoteFit]
FOR INSERT
AS
IF (SELECT DNFNO FROM INSERTED) IS NULL OR (SELECT DNFNO FROM INSERTED) = 0
BEGIN
UPDATE A
SET DNFNO=(SELECT MAX(DNFNO)+1 FROM DisNoteFit
WHERE DNMNum=A.DNMNum AND DNCNum=A.DNCNum AND DNFNum<=A.DNFNum)
FROM DisNoteFit A JOIN INSERTED B on A.DNFNum=B.DNFNum
END