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_TRV FOR 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
IF OBJECT_ID('TRGR_DVC_TRV') IS NOT NULL
DROP TRIGGER TRGR_DVC_TRV
GO
CREATE TRIGGER TRGR_DVC_TRV ON DVC_TRV FOR 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
扫一扫
811
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
