Sql Server 2008 trigger
sqlserver 2008 trigger:IF OBJECT_ID('TRGR_DVC_TRV') IS NOT NULL
DROP TRIGGER TRGR_DVC_TRV
GO
CREATE TRIGGER TRGR_DVC_TRV ON DVC_TRVFOR UPDATE AS
BEGIN
UPDATE DVC_TRV
SET VRSN_ID = D.VRSN_ID + 1,
LST_UPD_TIME = CURRENT_TIMESTAMP
FROM DVC_TRV SRC
INNER JOIN DELETED D
ON D.ID = SRC.ID
END
GO
页:
[1]