【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“实例321应用触发器向员工表添加数据并初使化工资表.sql”一文,供大家参考学习!
/*打开数据库*/
USE db_
sql2000
/*判断表中是否有名为“员工工资触发器”的触发器*/
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = '员工工资触发器'
AND type = 'TR')
/*如果已经存在则删除*/
DROP TRIGGER 员工工资触发器
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
/*创建新的触发器*/
CREATE TRIGGER 员工工资触发器 ON dbo.[tb_employee17]
FOR INSERT
AS
/*参数声明*/
DECLARE @eID varchar(50),@ePay decimal(9,2)
/*给参数赋值*/
set @ePay= 1000
/*应用触发器中的INSERTED表临时存储参数*/
select @eID=员工编号 From INSERTED
insert into tb_laborage17(员工编号,基本工资)values(@eID,@ePay)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO