我想插入在某个表在新建/修改/删除符合一定规则时,如某字段值>100,就向另一日志表写入一条记录,但是不知道怎么写读取新建修改删除的操作。请帮忙,谢谢了
create trigger trigger_1
on table1
for insert,delete,update
as
INSERT Trigger_Stakeout (col1, col2, col3)
select ???????????????????????????? from ??
这里怎么同时能读取我需要的insert,delete,update的信息呢?
create trigger trigger_1
on table1
for insert,delete,update
as
INSERT Trigger_Stakeout (col1, col2, col3)
select ???????????????????????????? from ??
这里怎么同时能读取我需要的insert,delete,update的信息呢?
delete操作无inserted表
所以你要分别写,或者在语句中进行检测
--例如,删除前如某字段值>100,
create trigger trigger_1
on table1
for delete
as
INSERT Trigger_Stakeout (col1, col2, col3)
select col1, col2, col3 from deleted
where 字段值>100
go
on table1
for insert,delete,update
as
INSERT Trigger_Stakeout (col1, col2, col3,类型)
select ...,'改后或者插入' from inserted
where 某字段值>100
union all
select ...,'改前或者删除' from deleted
where 某字段值>100