SQL触发器求救

来源：百度知道编辑：UC知道时间：2024/05/22 12:11:36

两张表删除一张表中的学生纪录后，触发删除另一张表的相应纪录

create trigger 名
for delete as
delete from 表 where 字段 = deleted.字段
注意，deleted是主表删除的。

CREATE TRIGGER [TRIGGER NAME] ON [dbo].[sysfiles]
FOR DELETE
AS
delete from tablename where tabllename.[字段]=deleted.[字段]

SQL触发器 求救