sql-server数据库中利用触发器实现表与表之间的级联删除
时间:2021-07-01 10:21:17
帮助过:2人阅读
as
declare @sno varchar(20)
select @sno= sno
from deleted
delete from score
where sno=
@sno
delete from student
where sno=
@sno
go
delete from Student
where Sno=
‘101‘
select *
from Student
select *
from Score
sql-server数据库中利用触发器实现表与表之间的级联删除
标签: