fdw0.sql

来自「这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代」· SQL 代码 · 共 36 行

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