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
转载于:https://www.cnblogs.com/highmayor/archive/2009/06/29/1513291.html