用触发器:
语法是这样的!!CREATE TRIGGER 触发器名 ON dbo.表名1
FOR DELETE
AS/*定义一个变量*/
declare @DelID int
begin select @DelID=字段1
from deleted delete from dbo.表名2
where 字段2=@DelIDend
语法是这样的!!CREATE TRIGGER 触发器名 ON dbo.表名1
FOR DELETE
AS/*定义一个变量*/
declare @DelID int
begin select @DelID=字段1
from deleted delete from dbo.表名2
where 字段2=@DelIDend
DELETE FROM SecTbl
FROM SecondaryTable SecTbl
INNER JOIN deleted d
ON SecTbl.col1 = d.col1