我正在尝试创建一个基本的数据库触发器,当从database2.table2删除一行时,该触发器有条件地从database1.table1中删除行。我是触发器的新手,我希望学习实现这一点的最好方法。这就是我到目前为止所拥有的。有什么建议吗?
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
https://stackoverflow.com/questions/9996643
复制相似问题