cp_update.sql

vbsql做的销售管理课程设计样本不完全仅为范例

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