将被改动的数据插入到备份表,方便追踪数据修改记录;
CREATE trigger [dbo].[tgr_Product_update]
on [dbo].[Product]
for update
as
set nocount on
BEGIN
insert into Product_backup select * from Deleted
END
set nocount off
on [dbo].[Product]
for update
as
set nocount on
BEGIN
insert into Product_backup select * from Deleted
END
set nocount off
红色部分代码,是必须要添加的。