SQLServer触发器

最新推荐文章于 2023-10-17 12:21:48 发布

小明珠

最新推荐文章于 2023-10-17 12:21:48 发布

阅读量109

点赞数

文章标签： sqlserver 数据库 database

本文链接：https://blog.csdn.net/u013631380/article/details/121700256

版权

本文介绍如何在SQL Server中创建了一个名为`realDBToDynReal`的触发器，它在`RealDB`表插入或更新时，检查配置并根据规则将数据同步到`dyn_real`表。触发器通过`dt_db2db_conf`表的匹配来决定是否删除旧记录并插入新的数据项。

摘要由CSDN通过智能技术生成

SQLServer触发器

USE [cdy.business]
GO
/****** Object: Trigger [dbo].[realDBToDynReal] Script Date: 2021/12/3 15:41:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER TRIGGER [dbo].[realDBToDynReal]
ON [dbo].[RealDB]
for insert,update
AS
DECLARE @IFHAVE numeric
begin
set @IFHAVE=(SELECT targetid FROM dbo.[dt_db2db_conf] WHERE SOURCEID=(select senid from inserted))
begin
IF(@IFHAVE >0)
BEGIN
delete from dbo.dyn_real where tm = (select time from inserted) and data_id = @IFHAVE

INSERT INTO [dbo].[dyn_real]
([data_id]
,[TM]
,[value]
,[flag])
VALUES
(@IFHAVE,(select time from inserted),(select factv from inserted),1)
end
end
end