创建一个行级别触发器,将从emp表中删除的记录输入到ret_emp表中.
1个回答
展开全部
create trigger tri_emp_delete on emp for delete
as
declare @rc as int
set @rc = @@rowcount;
if @c = 0 return
insert into ret_emp select * from deleted
if @@error <> 0
begin
RAISERROR ('Insert into ret_emp failed!', 16, 1)
rollback transaction
end
as
declare @rc as int
set @rc = @@rowcount;
if @c = 0 return
insert into ret_emp select * from deleted
if @@error <> 0
begin
RAISERROR ('Insert into ret_emp failed!', 16, 1)
rollback transaction
end
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
