fdw1.sql

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

USE db_10

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
 DECLARE @iJBGZ int
SELECT @iBH = 薪资编号 FROM INSERTED
SELECT @iJBGZ = 部门工资统计表.基本工资 FROM 部门工资统计表 WHERE 部门工资统计表.薪资编号=@iBH
update 明细工资表 set 基本工资= @iJBGZ  where 薪资编号 = @iBH

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO