use Instead Of Insert triggerCREATE TRIGGER InsteadTrigger on YourTable
INSTEAD OF INSERT
AS
BEGIN
---check if data exists using the data from inserted table
---if yes, do UPDATE YourTABLE with the data from inserted table
---if no, do insertion
END
GO
INSTEAD OF INSERT
AS
BEGIN
---check if data exists using the data from inserted table
---if yes, do UPDATE YourTABLE with the data from inserted table
---if no, do insertion
END
GO
CREATE TRIGGER T_INSERT ON TABLENAME
INSTEAD OF INSERT
AS
BEGIN
IF EXISTS(SELECT PRMKEY FROM TABLENAME WHERE PRMKEY=(SELECT PRMKEY FROM inserted))
BEGIN
DELETE TABLENAME WHERE PRMKEY=(SELECT PRMKEY FROM inserted)
END
INSERT INTO TABLENAME SELECT * FROM inserted
ENDGO
INSTEAD OF INSERT
AS
delete 表 where 编号 in (select 编号 from inserted)
insert 表 form inserted