【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供inserted触发器.sql参考,解决您在inserted触发器.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.[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='撒旦'