仅当满足第一个表中的条件时才触发更新第二个表 [英] Trigger to update 2nd table only when a condition is satisfied in the 1st table

问题描述

在插入的表(第一个表)中满足条件后，谁能帮我写一个触发器来更新第二个表.
问候，
Meenakshi Viswanathan

Hi,
can anyone help me to write a trigger to update 2nd table after a condition is satisfied in the inserted table(1st table).
Regards,
Meenakshi Viswanathan

推荐答案

创建TRIGGER测试

开启
表1
对于插入，更新
AS
开始
设置NOCOUNT ON
INSERT INTO table2
(
名称，地址，状态
)
SELECT
名称，地址，状态
FROM插入的AS table1，其中name = table1.name和Status =''Confirmed''
END

Create TRIGGER test

ON
table1
FOR INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON
INSERT INTO table2
(
name,address,Status
)
SELECT
name,address,Status
FROM Inserted AS table1 where name=table1.name and Status=''Confirmed''
END

创建TRIGGER测试

开启
表1
对于插入，更新
AS
开始
设置NOCOUNT ON
INSERT INTO table2
(
名称，地址，状态
)
SELECT
名称，地址，状态
FROM插入的AS table1，其中name = table1.name和Status =''Confirmed''
END

Create TRIGGER test

ON
table1
FOR INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON
INSERT INTO table2
(
name,address,Status
)
SELECT
name,address,Status
FROM Inserted AS table1 where name=table1.name and Status=''Confirmed''
END

这篇关于仅当满足第一个表中的条件时才触发更新第二个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！