【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供fdw0.sql参考,解决您在fdw0.sql学习中工作中的难题,参考学习。
USE mrdb
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = '基本工资触发器'
AND type = 'P')
DROP PROCEDURE 基本工资触发器
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE TRIGGER 基本工资触发器 ON dbo.[部门工资统计表]
FOR UPDATE
AS
DECLARE @iBH int
SELECT @iBH = 薪资编号 FROM INSERTED
update 明细工资表 set 奖金 = 奖金+50 where 薪资编号 = @iBH
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO