TR_PDCOMPOSITESEGMENTMAPPINGENTRY_IUD

Definition

Copy


                CREATE trigger [dbo].[TR_PDCOMPOSITESEGMENTMAPPINGENTRY_IUD] on [dbo].[PDCOMPOSITESEGMENTMAPPINGENTRY]
                after insert, update, delete not for replication
                    as 
                    begin
                        set nocount on
                        update dbo.PDCOMPOSITESEGMENTMAPPING set PDCOMPOSITESEGMENTMAPPING.COMPOSITESEGMENTKEY = dbo.UFN_PDCOMPOSITESEGMENTMAPPING_KEY(I.PDCOMPOSITESEGMENTMAPPINGID) from inserted I where PDCOMPOSITESEGMENTMAPPING.ID = I.PDCOMPOSITESEGMENTMAPPINGID    

                    end