TR_INSTALLMENT_INSERTUPDATE_RECEIPTAMOUNT (Trigger)

                
                    create trigger dbo.TR_INSTALLMENT_INSERTUPDATE_RECEIPTAMOUNT on dbo.INSTALLMENT
                    after insert, update
                    not for replication
                    as
                    begin
                        if update(AMOUNT)
                        begin
                            update dbo.INSTALLMENT
                            set
                                INSTALLMENT.RECEIPTAMOUNT = inserted.AMOUNT,
                                INSTALLMENT.CHANGEDBYID = INSTALLMENT.CHANGEDBYID,
                                INSTALLMENT.DATECHANGED = INSTALLMENT.DATECHANGED
                            from inserted
                                inner join dbo.INSTALLMENT on inserted.ID = INSTALLMENT.ID
                            where inserted.RECEIPTAMOUNT > inserted.AMOUNT
                        end
                    end