CREATE TRIGGER TR_TABLE1_UPDATE ON TABLE1 FOR UPDATE AS IF NOT UPDATE(TIME) --这个判断防止循环触发 UPDATE TABLE1 SET TIME=GETDATE() FROM TABLE1 T,INSERTED I WHERE pk=I.pk --pk是主键字段 GO
CREATE TRIGGER TR_TABLE1_UPDATE ON TABLE1 FOR UPDATE AS IF NOT UPDATE(TIME) --这个判断防止循环触发 UPDATE TABLE1 SET TIME=GETDATE() FROM TABLE1 T,INSERTED I WHERE T.pk=I.pk --pk是主键字段 GO
ON TABLE1
FOR UPDATE
AS
IF NOT UPDATE(TIME) --这个判断防止循环触发
UPDATE TABLE1
SET TIME=GETDATE()
FROM TABLE1 T,INSERTED I
WHERE pk=I.pk --pk是主键字段
GO
ON TABLE1
FOR UPDATE
AS
IF NOT UPDATE(TIME) --这个判断防止循环触发
UPDATE TABLE1
SET TIME=GETDATE()
FROM TABLE1 T,INSERTED I
WHERE T.pk=I.pk --pk是主键字段
GO