SQL数据库求助!!!针对employee表写一个DELETE触发器,显示删除的员工人数。咋编啊?

2025-06-22 01:31:37
推荐回答(1个)
回答1:

create trigger [employee_delete] on dbo.employee
for delete
as

declare @num int
set @num=0
select @num=count(*) from deleted
print @num