Question

SQL SERVER 2005 创建触发器

要创建一个触发器，对corp表的insert，update,delete 都要触发，触发后将corp表的所有字段插入corp_bak表，并在最后加个字段op，insert时op=1，update时op=2，delete时op=3，corp表字段设定为ID,MC,NUM

Answer 1

Create Trigger Tr_ForCorp
for insert，update,delete
on Corp
as
begin
Declare @Inserted int,@Deleted int
Set @Inserted = 0
Set @Deleted = 0
Select @Inserted = count(*) from Inserted
Select @Deleted = count(*) from Deleted

if @Inserted > 0 and @Deleted = 0 ---说明是插入触发
insert into corp_bak select *,1from inserted

if @Inserted > 0 and @Deleted > 0 ---说明是更新触发
insert into corp_bak select *,2 from inserted

if @Inserted = 0 and @Deleted > 0 ---说明是删除触发
insert into corp_bak select *,3 from inserted

end;

Answer 2

本来想写的，但是上面些的很详细了