触发器和存储过程简单实例

在table1上创建触发器，当在table1上insert时，同时插入table2:

create trigger trig_Myinsert
on table1
for insert
as
insert into table2
select *  
from
inserted
go

如果使用了自动增长列，需要显式的指定插入的列:

if exists (select name from sysobjects where name='trig_Myinsert')
drop trigger trig_Myinsert
go
create trigger trig_Myinsert
on table1
for insert
as
insert into table2 (username,age,sex)
select username,age,sex  
from
inserted
go


测试语句:

insert into table1 values ('mm',20,'m')