SQL Server ON DELETE触发器

本文介绍了SQL Server ON DELETE触发器的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在尝试创建一个基本的数据库触发器，当从database2.table2中删除一行时，有条件地从database1.table1中删除行。我是触发器的新手，并希望学习实现此目标的最佳方法。到目前为止，这就是我所拥有的。

I'm trying to create a basic database trigger that conditionally deletes rows from database1.table1 when a row from database2.table2 is deleted. I'm new to triggers and was hoping to learn the best way to accomplish this. This is what I have so far. Suggestions?

CREATE TRIGGER sampleTrigger
    ON database1.dbo.table1
    FOR DELETE
AS
    IF EXISTS (SELECT foo
               FROM database2.dbo.table2
               WHERE id = deleted.id
               AND bar = 4)

-- If there is a row that exists in database2.dbo.table2
-- matching the id of the deleted row and bar=4, delete
-- it as well.

-- DELETE STATEMENT?

GO

推荐答案

CREATE TRIGGER sampleTrigger
    ON database1.dbo.table1
    FOR DELETE
AS
    DELETE FROM database2.dbo.table2
    WHERE bar = 4 AND ID IN(SELECT deleted.id FROM deleted)
GO

这篇关于SQL Server ON DELETE触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！