sql server触发器及存储过程

create proc proc_6 
 as
 select * from person;
 select * from users;
go


exec proc_6


create trigger tr_1 on users after insert
as
select * from inserted


drop trigger tr_2


create trigger tr_2 on users after insert
as
declare @var1 varchar(50)
select @var1=name from inserted
insert into person values(@var1)


insert into users values('ad2',22,'男','郴州嘉禾');


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;