没看明白你写的东东,在insert 的触发器中怎么能有 deleted表呢?------------------
create trigger t_FirstLevelTitle
on FirstLevelTitle
for instead
asdelete t from SecondLevelTitle t inner join inserted on t.ParentTitle = a.id
create trigger t_FirstLevelTitle
on FirstLevelTitle
for instead
asdelete t from SecondLevelTitle t inner join inserted on t.ParentTitle = a.id
我删除主键,可是外键有内容,所以我想,我一删除主键,外键的内容自动删除!
这里就用一个触发器用 instead和insert 不同,我也忘了!但是用这个instead是可以删除外键,再删除主键的!
add constraint 名稱 foreign key(id) references t1(id) on delete cascade