USE [AdventureWorks2014]
GO
/****** Object:  Trigger [Person].[onUpdatePersonPassword]    Script Date: 01.05.2023 18:09:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER TRIGGER [Person].[onUpdatePersonPassword] ON [Person].[Password]
   AFTER UPDATE
AS
BEGIN
	UPDATE [Person].[Password]
	SET [Password].[ModifiedDate] = GETDATE()
	WHERE BusinessEntityID = (SELECT BusinessEntityID from inserted)
END