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);