背景:常见的表会有一个updatedate字段,用来标示表中数据最近一次被更新的时间
该功能可由程序实现(不再赘述),也可以由触发器实现
USE [test]
GO
/****** Object: Trigger [dbo].[AutoDateModified] Script Date: 04/12/2010 17:37:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[AutoDateModified]
ON [dbo].[Table_1]
FOR UPDATE
AS
BEGIN
--减小网络传输
SET NOCOUNT ON
UPDATE t SET t.updateDate = GETDATE()
FROM Table_1 t
JOIN deleted d ON t.id = d.id --deleted临时表
END