TR_CLIENTUSERS_INSERT

Definition

Copy


            CREATE TRIGGER [dbo].[TR_CLIENTUSERS_INSERT] ON [dbo].[CLIENTUSERS] AFTER INSERT NOT FOR REPLICATION
            AS
            begin
                begin
                    insert into [ClientUserPasswordHistory] ([UserID],[Password]) 
                        select INSERTED.ID, INSERTED.password from INSERTED 
                        where INSERTED.Password is not null
                end
            end