【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“实例314创建递归触发器,实现只允许一次删除一条记录.sql”一文,供大家参考学习
/*打开数据库*/
use db_
sql2000
/*判断表中是否有名为“delete_employee”的触发器*/
if EXISTS (SELECT name
FROM sysobjects
WHERE name = 'delete_employee'
AND type = 'TR')
/*如果已经存在则删除*/
drop trigger delete_employee
go
create trigger delete_employee
on tb_employee17
after delete as
declare @rowcount int
select @rowcount = @@rowcount
if @rowcount>1
begin
rollback transaction
print('当前删除的记录条数大于一条,一次只允许删除一条')
end
if @rowcount=1
begin
declare @所属部门 varchar(50)
select @所属部门 = 所属部门 from deleted
delete from tb_employee17 where 所属部门 = @所属部门
end
go