sql-server数据库中利用触发器实现表与表之间的级联删除
标签：
sql-server数据库中利用触发器实现表与表之间的级联删除
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