功能很简单,如果某个字段修改了,将本表的另个字段进行更新
直接将代码贴上。
Code
ALTER TRIGGER [dbo].[TR_MS_USER_PASSWORD_U]
ON [dbo].[MS_USER]
FOR UPDATE
AS
SET NOCOUNT ON
IF UPDATE(PASSWORD)
BEGIN
UPDATE [dbo].[MS_USER]
SET [PASSWORD_MODIFY_ON] = GETDATE()
WHERE USER_ID IN (SELECT USER_ID FROM INSERTED)
END
SET NOCOUNT OFF
ALTER TRIGGER [dbo].[TR_MS_USER_PASSWORD_U]
ON [dbo].[MS_USER]
FOR UPDATE
AS
SET NOCOUNT ON
IF UPDATE(PASSWORD)
BEGIN
UPDATE [dbo].[MS_USER]
SET [PASSWORD_MODIFY_ON] = GETDATE()
WHERE USER_ID IN (SELECT USER_ID FROM INSERTED)
END
SET NOCOUNT OFF