触发器

--创建触发器
create trigger trigger_name
on {table_name | view_name}
{for | After | Instead of }
[ insert, update,delete ]
as
sql_statement

--创建触发器具体示例
create trigger trigger_test 
on table_A
after insert 
as 
insert into table_B(col_b1) select (col_a1) from inserted

-- 删除触发器
drop trigger trigger_name

-- 查看数据库已有触发器
use datebase_name
go
select * from sysobjects where xtype='TR'

-- 查看单个触发器
exec sp_helptext 'trigger_name'

-- 修改触发器
alter trigger trigger_name
on {table_name | view_name}
{for | After | Instead of }
[ insert, update,delete ]
as
sql_statement

-- 修改触发器具体示例
alter trigger trigger_test
on table_A
alter insert
as
insert into table_B(col_b1) select (col_a2) from inserted

-- 当积分记录表[PointLog]中有插入操作时就要更新表Company中总积分
CREATE TRIGGER TR_PointUpdate 
ON PointLog
AFTER INSERT 
AS 
    DECLARE @CompanyID INT
    SELECT @CompanyID=CompanyID from inserted
    UPDATE Company SET JF=JF+(SELECT PointChange FROM inserted) WHERE CompanyID=@CompanyID
GO