现要监控assets表,当assets里出现删除一条或多条数据时,触发器就删除数据的对应id插入另一张表 asset_temp,很基础的问题,请帮忙.
Create Trigger Delete_log ON assets for delete as
begin
insert into asset_temp select id from assets where id in(select id from deleted)
end
Create Trigger Delete_log ON assets for delete as
begin
insert into asset_temp select id from assets where id in(select id from deleted)
end
Create Trigger Delete_log ON assets for delete as
begin
insert into asset_temp select id from deleted
end
create trigger Delete_log
on assets
for delete
as
declare @id int
select @id = id from deleted
insert into asset_temp(id) values(@id)