TR_CLIENTUSERS_UPDATE (Trigger)

            CREATE TRIGGER [dbo].[TR_CLIENTUSERS_UPDATE] ON [dbo].[CLIENTUSERS] AFTER UPDATE NOT FOR REPLICATION
            AS
            begin
                if (update(PASSWORD))
                begin
                    insert into [ClientUserPasswordHistory] ([UserID],[Password]) 
                        select INSERTED.ID, INSERTED.password from INSERTED inner join DELETED on INSERTED.ID=DELETED.ID
                        where DELETED.Password<>INSERTED.Password and INSERTED.Password is not null
                end
            end