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;