【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供346.sql参考,解决您在346.sql学习中工作中的难题,参考学习。
use db_sql
go
/*为tb_teacher17表创建DELETE触发器*/
create trigger teacher_delete
on tb_teacher17
after delete as
declare @rowcount int
select @rowcount=@@rowcount /*删除操作所涉及的记录行数*/
if @rowcount >1 /*判断删除的记录是否多余一行*/
begin
rollback transaction
print('删除tb_teacher17表中记录多余一条,删除失败')
end
else
declare @教师 varchar(10) /*删除记录的“教师”列信息*/
select @教师 = 教师 from deleted
delete tb_school17 where 教师 = @教师
/*为tb_school17表创建DELETE触发器*/
go
create trigger school_delete
on tb_school17
after delete as
declare @rowcount int
select @rowcount = @@rowcount /*删除操作所涉及的记录行数*/
if @rowcount >1 /*判断删除的记录是否多余一行*/
begin
rollback transaction /*回滚操作*/
print('删除tb_school17表中记录多余一条,删除失败')
end
else
print('tb_school17表和tb_teacher17表中相应的数据均被删除')
select * from tb_teacher17
select * from tb_school17