【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:347.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
use db_
sql 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(10)
select @所属部门 = 所属部门 from deleted
delete from tb_employee17 where 所属部门 = @所属部门
end
delete from tb_employee17 where 编号='08001'