CREATE trigger [test] on [oo]
for insert,delete,update
as
begin
declare @ins_count int,
@del_count int    if @@rowcount = 0 return

select @ins_count=count(*) from inserted 
select @del_count=count(*) from deleted    if @del_count>0 begin
insert into oodel select * from deleted    end
if @ins_count>0 begin
insert into ooins select * from inserted    end
end

引言: 以下紅色部份可以只insert into被select的record其中幾個欄位?而不是 整個record都insert into

CREATE trigger [test] on [oo]
for insert,delete,update
as
begin
declare @ins_count int,
@del_count int    if @@rowcount = 0 return

select @ins_count=count(*) from inserted 
select @del_count=count(*) from deleted
-- 只是取得 inserted 與 deleted 兩個 "暫存檔", 以方便判斷 增刪修.    if @del_count>0 begin
insert into oodel select * from deleted
-- insert into oodel(f1,f2...) selecct f1,f2... from deleted
end
if @ins_count>0 begin
insert into ooins select * from inserted    end
end

堅持從洗馬桶做起 Eric