在SQL SERVER上创建触发器用于删除 [英] Create Trigger on SQL SERVER For delete

问题描述

hi
我想在SQL Server 2012上创建一个TRIGGER

我有2个表。

当用户尝试删除表1中的记录时，如果这个记录在表格中，

回滚交易和用户无法删除。

感谢

hi I want to create a TRIGGER on SQL Server 2012
I have 2 table.
when user try to delete a record from table one,if this record was in table tow,
rollback transaction and user can not delete.
thank

推荐答案

你需要使用INSTEAD OF关键字。

You will want use the INSTEAD OF keywords.

CREATE TRIGGER [name] ON [table] INSTEAD OF DELETE AS

在触发器中你可以用select语句检查它是否可以删除运行

In the trigger you can check with a select statement and if it is deleteable run

DELETE FROM [table] FROM [Table] a INNER JOIN deleted d ON a.[key] = d.[key]

祝你好运

Good Luck

这篇关于在SQL SERVER上创建触发器用于删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！