triggerdemo15.sql

T-SQL示例大全

/*
文件名称: TriggerDemo15.sql
*/
USE 北风贸易
GO

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.ColumnStatusTrigger') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger dbo.ColumnStatusTrigger
GO

CREATE TRIGGER ColumnStatusTrigger ON 章立民工作室
FOR UPDATE
AS
IF ( (SUBSTRING(COLUMNS_UPDATED(),1,1)=POWER(2,(4-1))
      + POWER(2,(6-1))) 
      AND (SUBSTRING(COLUMNS_UPDATED(),2,1)=POWER(2,(1-1)) + POWER(2,(2-1)))
      ) 
   PRINT '第 4、6、9、10 个字段皆已被修改'

GO

-- 试着更新「章立民工作室」数据表的第 4、6、9、10 个字段
UPDATE 章立民工作室
     SET 性别 = '女',
             邮政编码 = '01266',
             雇用日期 = '01/05/1994',
             起薪 = 37163.0000
     WHERE 员工编号 = 1

GO