数据库综合系列之触发器

--创建insert插入类型触发器
if (object_id('tgr_classes_insert', 'tr') is not null)
    drop trigger tgr_classes_insert
go
create trigger tgr_classes_insert
on manage
    for insert --插入触发
as
    --定义变量
    declare  @name varchar(20), @temp varchar(20);
    --在inserted表中查询已经插入记录信息
    select  @name = m_name,@temp=m_password from inserted;
    set @name = @name + 'buyingfei';
    insert into t_director values(@name, @temp,'男','2010-10-10','11111111112',1);
    print '添加成功！';

insert into manage values('经理','11111111112','男','2010-10-10','11111111112',2)

CREATE TRIGGER t1 ON  manage
for delete
AS 
If  (select count(*) from t_cash_housewoker  where m_id=t_cash_housewoker.m_id)>0
    BEGIN      
      Rollback tran
      Print 'the manager is userful, you can not delete it'     
   END	

delete from manage where m_id='3'

if (object_id('tgr_classes_update_column', 'TR') is not null)
    drop trigger tgr_classes_update_column
go
create trigger tgr_classes_update_column
on manage
    for update
as
    --列级触发器：是否更新了班级创建时间
    if (update(m_name))
    begin
        raisError('系统提示：班级创建时间不能修改！', 16, 11);
        rollback tran;
    end

update manage set m_name='buyingfei' where m_id='1'