cp_update.sql

来自「vbsql做的销售管理课程设计样本不完全仅为范例」· SQL 代码 · 共 18 行

USE cpxs
GO
IF EXISTS(SELECT name FROM sysobjects 
WHERE xtype= 'TR' AND name ='trig_update')
DROP TRIGGER trig_update
GO
CREATE   TRIGGER trig_update on dbo.cp
FOR UPDATE
AS
BEGIN
IF(COLUMNS_UPDATED()&01)>0
UPDATE xscp 
SET cpbh=(SELECT ins.cpbh from INSERTED ins)
WHERE  cpbh=(SELECT cpbh FROM deleted)
END