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