触发器的简单用法

create table tbl1
(
    id int identity(1,1) primary key,
    name nvarchar(10)
);
create table tbl2
(
    id int identity(1,1) primary key,
    name nvarchar(10)
);



go
create trigger tr_insert on tbl1--修改触发器用alter trigger
for    insert--当tbl1表执行插入数据时,把插入的name字段存到tbl2里面
as
    insert into tbl2 select name from inserted;
go

go--针对tbl1删除操作的触发器
create trigger tr_deleteTest on tbl1
for    delete
as
    insert into tbl2(name) select name from deleted;
go

go--针对tbl1修改的触发器
create trigger tr_updateTest on tbl1
for  update
as
    select '禁止修改';
go

update tbl1 set name = '介似一个名字';

select * from tbl1;--看看改没改