Create trigger delstudent on student for delete as delete from studentinfo s,delete d where s.id=d.id
create trigger trg_tbl1_del on 学生信息 for delete as delete a from 学生成绩表 a,deleted b where a.学号=b.学号
实在抱歉,没有测试,写错了语句,bqb(萧雨) 的是对的. create table studentinfo(id int,name varchar(20)) create table student(id int, int) go insert studentinfo select 1,'学生1' union all select 2,'学生2' union all select 3,'学生3' union all select 4,'学生4' union all select 5,'学生5' union all select 6,'学生6' union all select 7,'学生7'insert student select 1,83 union all select 2,85 union all select 3,45 union all select 4,89 union all select 5,87go create trigger trg_tbl1_del on studentinfo for delete as delete a from student a join deleted b on a.id=b.id--或者: create trigger trg_tbl1_del on studentinfo for delete as delete student from student a join deleted b on a.id=b.idgo --test delete from studentinfo where id=1select * from studentinfo select * from studentdelete from studentinfo where id in (3,5)select * from studentinfo select * from studentdrop trigger trg_tbl1_del drop table studentinfo drop table student
create trigger tri_del on 学生信息表 for delete as begin delete from 学生成绩表 where 学号 in (select 学号 from deleted) end
for delete
as
delete from 学生成绩表 a join deleted b on a.学号=b.学号
第 4 行: 'a' 附近有语法错误。 不能运行
on student
for delete
as
delete from studentinfo s,delete d
where s.id=d.id
for delete
as
delete a from 学生成绩表 a,deleted b where a.学号=b.学号
create table studentinfo(id int,name varchar(20))
create table student(id int, int)
go
insert studentinfo select 1,'学生1'
union all select 2,'学生2'
union all select 3,'学生3'
union all select 4,'学生4'
union all select 5,'学生5'
union all select 6,'学生6'
union all select 7,'学生7'insert student select 1,83
union all select 2,85
union all select 3,45
union all select 4,89
union all select 5,87go
create trigger trg_tbl1_del on studentinfo
for delete
as
delete a from student a join deleted b on a.id=b.id--或者:
create trigger trg_tbl1_del on studentinfo
for delete
as
delete student from student a join deleted b on a.id=b.idgo
--test
delete from studentinfo where id=1select * from studentinfo
select * from studentdelete from studentinfo where id in (3,5)select * from studentinfo
select * from studentdrop trigger trg_tbl1_del
drop table studentinfo
drop table student
for delete
as
begin
delete from 学生成绩表
where 学号 in (select 学号 from deleted)
end