inserted触发器.sql

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

/*打开数据库*/
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.[employeeInfo]
FOR INSERT
AS
/*参数声明*/
DECLARE @eID int,@eName varchar(50),@ePay decimal(9,2)
/*给参数赋值*/
set  @ePay= 1000
/*应用触发器中的INSERTED表*/
select @eID=EmpID,@eName=EmpName From INSERTED
insert into employeePay(employeeID,employeeName,employeePay)values(@eID,@eName,@ePay)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO
insert into employeeInfo (EmpID,EmpName,Number,Phone)values(1,'撒旦','220104','1345678')
delete from employeeInfo where EmpName='撒旦'