TR_CLIENTUSERSCIPHER_UPDATE

Definition

Copy


        CREATE trigger [dbo].[TR_CLIENTUSERSCIPHER_UPDATE] ON [dbo].[CLIENTUSERSCIPHER] AFTER UPDATE NOT FOR REPLICATION
            AS
            begin
          if (update(CIPHER))
          begin
                      insert into [CLIENTUSERSCIPHERHISTORY] ([CLIENTUSERSID],[CIPHER],[ADDEDBYID],[CHANGEDBYID]) 
                          select INSERTED.CLIENTUSERSID, INSERTED.CIPHER, INSERTED.ADDEDBYID, INSERTED.CHANGEDBYID from INSERTED ;
          end
                end