TR_CLIENTUSERSCIPHER_INSERT

Definition

Copy


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