表1
id name content表2
id sname name content表3
id tname content
表1.name=表2.sname, 表2.name=表3.tname
怎么样删除表1里面的内容时候也删除表2和表3里面级联的内容?
delete from 表1 where name='"+KeyWord+"'
id name content表2
id sname name content表3
id tname content
表1.name=表2.sname, 表2.name=表3.tname
怎么样删除表1里面的内容时候也删除表2和表3里面级联的内容?
delete from 表1 where name='"+KeyWord+"'
declare @name ...
select @name=name from deleted
delete from 表2 where name = @namego.....