create trigger tr_stest_i on TableProduct for insert as insert 日志表 select * from inserted go create trigger tr_stest_i on TableProduct for delete as insert 日志表 select * from deleted go create trigger tr_stest_i on TableProduct for update as insert 日志表 select * from inserted go
--不知道這樣可以不? create trigger t1 on TableProduct for insert,update,delete AS if(update(col1) or update(col2) or update(col3) ..) begin insert into 日志表 select * from inserted end else begin insert into 日志表 select * from deleted end Go
as
insert 日志表
select * from inserted
go
create trigger tr_stest_i on TableProduct for delete
as
insert 日志表
select * from deleted
go
create trigger tr_stest_i on TableProduct for update
as
insert 日志表
select * from inserted
go
create trigger t1
on TableProduct
for insert,update,delete
AS
if(update(col1) or update(col2) or update(col3) ..)
begin
insert into 日志表 select * from inserted
end
else
begin
insert into 日志表 select * from deleted
end
Go
那update時,也要從deleted表抓.