说一种最常见的使用场景:
1.直接找到对应的表,新建触发器
2.举个例子,work表只要更新就直接修改更新时间为当前时间(不添加insert是因为该字段默认值为当前时间)。
ALTER TRIGGER [dbo].[afterWorkChange]
ON [dbo].[work]
AFTER UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
--数据修改
UPDATE work --表名
SET workUpdateTime = convert(varchar(23),getdate(),121)
From
inserted i
WHERE
work.id = i.id
END