×

SQL SERVER

SQL更新触发器(Update)

Kalet Kalet 发表于2019-07-31 15:53:24 浏览243 评论0

抢沙发发表评论


CREATE TRIGGER [hello] ON [dbo].[test]
FOR UPDATE AS
BEGIN
  update test set now1=GETDATE() WHERE ID IN (SELECT id FROM inserted)
END


 

群贤毕至

访客