触发器问题

[zblaoshu1979]

我想写一个触发器，是向CZRDAB表中插入数据之前判断是否CZRDAB表中存在主键ZBH有相同的记录，如果有，则删除记录原有记录后插入新记录.

[yujohny]

CREATE TRIGGER Tr_Test ON CZRDAB
INSTEAD OF INSERT
AS
DELETE FROM CZRDAB WHERE ZBH IN (SELECT ZBH FROM INSERTED)
INSERT INTO CZRDAB SELECT * FROM INSERTED

[junny1017]

create trigger triggername
ON CZRDAB
INSTEAD OF INSERT
AS
BEGIN
DELETE FROM CZRDAB WHERE ZBH IN (SELECT ZBH FROM INSERTED)
INSERT INTO CZRDAB (ZBH) select ZBH FROM INSERTED
END

[yujohny]

CREATE TRIGGER Ti_Test ON CZRDAB
INSTEAD OF INSERT
AS
DELETE CZRDAB WHERE ZBH IN (SELECT ZBH FROM INSERTED)
INSERT INTO CZRDAB SELECT * FROM INSERTED