SqlServer-INSTEAD OF INSERT触发器
Create TRIGGER [dbo].[TRIGGER_dms_rtdb_bjlx]
ON [dbo].[dms_rtdb_bjlx]
Instead Of INSERT
AS
BEGIN
set nocount on
delete dms_rtdb_bjlx where tableno=(SELECT top 1 tableno FROM inserted)
insert into dms_rtdb_bjlx SELECT * FROM inserted
END
