1:设置级联删除
2: 在Table1中写触发器
Create trigger yourTriggerName on Table1
For Update
As
Delete Table2 where ColB in (select ColA from Deleted)
2: 在Table1中写触发器
Create trigger yourTriggerName on Table1
For Update
As
Delete Table2 where ColB in (select ColA from Deleted)
Create trigger yourTriggerName on Table1
For Delete
As
Delete Table2 where ColB in (select ColA from Deleted)
方法1.
触发器--创建级联删除的触发器
create trigger t_delete on Table1
for delete
as
delete from Table2 where ColB in(select ColA from deleted)
go
--这样,执行下面的语句就可以级联删除了.
delete from table1 where cola='aa'
要注意的是,在删除Table1时应想删除Table2中的记录,因为两表有关联。