触发器

create table trigger_test(
 id int not null;
 name varchar(50)
 constraint t_testId primary key(id) 
)

当insert trigger_test时 更新name为test值

create trigger tri_test on trigger_test  after insert as update trigger_test set name='test' where id=(select id from inserted); go

测试：

insert into trigger_test values(1,null);